[AccessD] ODBC driver for Access 2019 to MySQL

[Jim Dettman]

 As a suggestion, delete the DNS's and re-create either prefixing or
suffixing the names with the bitness.   (i.e. MyDB_32)

 The reason is that there are two ODBC admin applets (one is in
C:\Windows\SysWOW64, which is for 32 bit DSNs, the other in
C:\Windows\System32 and is for 64 bit DSNs) and both are named odbcad32.exe

 Where the confusion really comes in is that both can show DSN's for the
other bitness depending on the type of DSN.   This was all done for
backwards compatibility, but it's confusing to no end.

 So it's best to always suffix the DSN names so you know what you are
looking at.

Jim.



-----Original Message-----
From: AccessD On Behalf Of John Colby
Sent: Wednesday, April 27, 2022 10:25 AM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] ODBC driver for Access 2019 to MySQL

I spoke too soon.

ODBC -- call failed.  It's telling me to look in a log file but not sure
where that log file is.

On Wed, Apr 27, 2022 at 10:15 AM Ryan W <wrwehler at gmail.com> wrote:

> File DSN's seem to be stored in My Documents
>
>
> On Wed, Apr 27, 2022 at 9:11 AM John Colby <jwcolby at gmail.com> wrote:
>
> > It appears that it was the bitness thing.  I did it over again with 32
> bit
> > and I now see two MySQL odbc drivers, ansi and unicode.
> >
> > I even created a DSN file.  Woohooo.  And I tested it successfully.
> > Amazing stuff.
> >
> > However, where the hell is it?  I am trying to actually use the silly
> thing
> > and the DSN isn't showing up.  Does windows store them all together in
> some
> > secret location?
> >
> > On Wed, Apr 27, 2022 at 8:05 AM Stuart McLachlan <stuart at lexacorp.com.pg
> >
> > wrote:
> >
> > > Yes.
> > >
> > > You need to download and instal the mySQL ODBC connector
> > >
> > > https://dev.mysql.com/downloads/connector/odbc/
> > >
> > >
> > >
> > > On 27 Apr 2022 at 5:43, John Colby wrote:
> > >
> > > > Does Microsoft allow Access to connect (link) to MySQL?
> > > >
> > > > I have a MySQL database on my web site.  It exists, has data, I have
> a
> > > > user and password.  I need to connect Access to that database.
> > > >
> > > > I am trying to create a dsn file and MySQL is not a choice for
> > > > drivers.  In fact the choices are distinctly slim pickings.  Mostl
> sql
> > > > server.
> > > >
> > > > Can anyone help me get this done?
> > > >
> > > > --
> > > > John W. Colby
> > > > Colby Consulting
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > >
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> >
> > --
> > John W. Colby
> > Colby Consulting
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
John W. Colby
Colby Consulting
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com