I followed the instructions and unfortunately, I can't get the ODBC to work. After installing iODBC, I went to test the datasource using iODBC test and I got the following message:
[MySQL][ODBC 3.51 Driver]No DNS entered
Just to clarify a few issues. When using iODBC, the first step was to open ODBC Drivers tab. Here I was asked for a description of the driver (I entered mysql). The next box asked for the Driver filename (I browsed to the driver in /Library/MyODBC/lib/). There are two files in this folder that could be the driver: libmyodbc3_r-3.51.06.bundle or libmyodbc3-3.51.06.bundle. I’ve tried both, but I’m not sure which one I should be using.
The next box asks for “Setup file name”. What goes in here?
I then went to the User DSN tab and I added a new User DSN. The first screen asks for the driver. I chose mysql.
I was then asked for the Data Source name. I used test. I entered the following key: value pairs: database: test;
username: root;
password: password.
I then tested the User DSN, but I get the error
[MySQL][ODBC 3.51 Driver]No DSN entered
Showing messages 1 through 2 of 2.
No DSN entered
2003-11-03 10:25:56
anonymous2
[View]
Ok, I got this to work. First of all, the iODBC test function often results in an error even when everything is working fine.
But the real cause of my problem, was that I had to configure MySQL to grant privileges to my user so that I could log on via iODBC.
But the real cause of my problem, was that I had to configure MySQL to grant privileges to my user so that I could log on via iODBC.
Andrew