[dba-Tech] MySQL gurus

[Gustav Brock]

Hi John

Eh ... how do you compare HTML with an ODBC connection? Seems totally unrelated to me - like oranges and, say, coffee ...

/gustav

-----Oprindelig meddelelse-----
Fra: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] På vegne af John R Bartow
Sendt: 26. november 2015 04:45
Til: 'Discussion of Hardware and Software issues' <dba-tech at databaseadvisors.com>
Emne: Re: [dba-Tech] MySQL gurus
Prioritet: Høj

It was all because I'm using 32 bit Access. Everything else involved was 64 bit (Windows, Windows Server, MySQL). 
Had it been 64 bit Access everything would have worked fine.

So the lesson learned is use 32 bit ODBC drivers with Access regardless of the data source.

As an aftermath though, I will say that the speed of the Access query I developed after importing the data from MySQL is phenomenal compared to trying to find it in HTML, RAW XML or XML Notepad.

Just to compare I think I'll make another Access DB with the data linked and see if it's any faster.

Any bets on that?