Topic: MySQL ODBC Support

[glc]

Anyway to get a Win2k machine to interact with a mysql database via Mircosoft Access and ODBC?

I tried the MyODBC program (http://www.mysql.com/downloads/api-myodbc.html), but can't get it to work.

[Noah]

Yes. I have this working fine for quite a few Win2K machines. Make sure you follow the directions closely. Create the ODBC connection and make sure you remember to do this:

"The user and Windows machine must have the access privileges to the MySQL server on the Unix machine. This is set up with the GRANT command."

There is a good tutorial here:

http://www.devshed.com/Server_Side/MySQL/ODBC/page1.html

Noah