MySQL ODBC Driver

Question

MySQL ODBC Driver

I have installed the MySQL ODBC driver on my system. When I open the ODBC Administrator the driver does not show up. Any ideas on how to make that happen?

Thanks for any advice...

G4 dual 1.25, Mac OS X (10.4.7)

Posted on Sep 5, 2006 1:07 PM

Reply

Answer 1

UNIXGuru

Level 1

125 points

Nov 12, 2006 8:50 AM in response to Jeffrey Laughlin

Yup, the driver you need to point to is:
/usr/lib/libmyodbc3.dylib

Once you have that you will need to make some pointers under User DSN.
Click Add, pick the driver, give the Data Source a name, then add a keyword with "SERVER" as the keyword and the IP adrress of the database server as the value. For instance, if mysql is running locally you would have "SERVER" and "127.0.0.1"

Click OK to save everything and you can now connect to that server from any ODBC database like FileMaker Pro.

Reply