[dba-Tech] MySQL gurus

[John R Bartow]

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. 

All of that just to bring in a SQL data dump from my RMS system so I could
search through my hundreds of client computer inventories to see who had the
Dell Foundation Services installed so that I could inform them of the recent
security certificate issue. I don't run the Dell Foundation Services updates
automatically (trust issues - apparently with just reason ;-) but I do have
home users that own Dell machines and I did find a few that have Dell
Foundation Services running on their machines. 

Thanks for your help.
John B

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

Have you tried creating a DSN connection?

Susan H.

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

> When I set up the ODBC connection it tests fine. When I try to connect 
> with Access I get the following error:
> ODBC -- call failed.
> [Microsoft][ODBC Driver Manager] The specified DSN contains an 
> architecture mismatch between the Driver and Application (#0)
>
> -----Original Message-----
> From: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] On 
> Behalf Of Susan Harkins
> Sent: Wednesday, November 25, 2015 7:20 AM
> To: Discussion of Hardware and Software issues
> Subject: Re: [dba-Tech] MySQL gurus
>
> On Wed, Nov 25, 2015 at 6:03 AM, Arthur Fuller 
> <fuller.artful at gmail.com>
> wrote:
>
> > ODBC connect to a 64 bit MySQL Unicode database
>
>
> I'm with Arthur -- all you need is the right connection string. Not 
> sure you'll find it here, but looks like a good start.
>
> <
>
> http://stackoverflow.com/questions/25210153/connecting-to-mysql-via-od
> bc-in-
> a-64-bit-system
> >
>
> Susan H.
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com