[AccessD] ODBC driver for Access 2019 to MySQL

[John Colby]

Never mind!  I just scrolled across in the default directory and there it
was.  I think I am connecting across the internet to my database.

Technology is a wonderful thing, once you figure it out.

On Wed, Apr 27, 2022 at 10: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
>


-- 
John W. Colby
Colby Consulting