[AccessD] ODBC driver for Access 2019 to MySQL

[John Colby]

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