[dba-Tech] MySQL gurus

[John R Bartow]

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?

-----Original Message-----
From: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of
Susan Harkins
Sent: Wednesday, November 25, 2015 3:45 PM
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] MySQL gurus

I just find it odd that the connection required 32 when you were working
with 64 -- am I missing something?

SUsan H.

On Wed, Nov 25, 2015 at 3:51 PM, John R Bartow <jbartow at winhaven.net> wrote:

> Hi Susan,
> Yes, I did create a System DSN without issue. The only problem was 
> with Access importing the data using the ODBC connection. I found the 
> problem was that I had created the DSN in the 64 bit ODBC Manager, 
> which is what is linked to in the control panel. I had to go find the 
> 32 bit ODBC Manager app in C:\Windows\sysWOW64 folder. Once I did that 
> I created a system System DSN, which used the 32 bit MySQL driver, 
> opened the ODBC connection in Access and everything came through 
> flawlessly.
>
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com