Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: glc on November 16, 2001, 01:35:09 AM

Title: MySQL ODBC Support
Post by: glc on November 16, 2001, 01:35:09 AM

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.

Title: Re: MySQL ODBC Support
Post by: Noah on November 17, 2001, 07:54:04 PM

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