[AccessD] ODBC driver for Access 2019 to MySQL

[Ryan W]

You may need to grant remote privileges:

https://rtcamp.com/tutorials/mysql/remote-access/



On Wed, Apr 27, 2022 at 9:25 AM John Colby <jwcolby at gmail.com> wrote:

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