Hello All:
I am trying to configure ODBC for MySQL but have been unable to make a connection.
We are running MySQL 4.0.15 supplied by Server Logistics on OS X 10.3.5.
I have installed their ODBC Driver and 4 files show up in the library/MyODBC/Lib/ directory:
libmyodbc3_r-3.51.06.bundle
libmyodbc3_r.bundle (alias)
libmyodbc3-3.51.06.bundle
libmyodbc3.bundle (alias)
Under the ODBC Admin I have added a driver with the name mysqlreporting specifying the driver file path as :
/Library/MyODBC/lib/libmyodbc3-3.51.06.bundle.
Didn't know what to put for setup file so the path is the same. I then setup 3 key values:
keyword Value user userloginname password userpasswordname database mydatabase
Under UserDSN, I add the above driver naming the data source name also mysqlreporting.
I also enter the same keyvalues.
When I go to test the connection locally, I get the following:
Last login: Fri Nov 5 09:26:40 on ttyp1 Welcome to Darwin! My-Computer:~ myuserlogin$ /usr/bin/odbctest iODBC Demonstration program This program shows an interactive SQL processor
Enter ODBC connect string (? shows list): ?
DSN | Description --------------------------------------------------------------- mysqlreporting | mysqlreporting
Enter ODBC connect string (? shows list): dsn=mysqlreporting
[iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded, SQLSTATE=IM002
Have a nice day. My-Computer:~ myuserlogin$
Can someone explain what I am doing wrong. Because their are two different drivers in the MyODBC Lib folder, I tried both but get the same message.
Thanks. Rick
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
