[dba-Tech] MySQL gurus

[Susan Harkins]

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.
>