I am trying to configure iODBC on Debian Lenny. When i try to test the configuration with iodbctest the following message is printed:
SQLDriverConnect = [MySQL][ODBC 3.51 Driver] Could not determine the driver name; could not lookup setup library. DSN=((null)) SQLSTATE=HY000
ODBC_Connect = [MySQL][ODBC 3.51 Driver] Could not determine the driver name; could not lookup setup library. DSN=((null)) SQLSTATE=HY000
The content of /etc/odbc.ini
Code:
;
; odbc.ini configuration for MyODBC and MyODBC 3.51 Drivers
;
[ODBC Data Sources]
myodbc = MySQL ODBC 2.50 Driver DSN
myodbc3 = MySQL ODBC 3.51 Driver DSN
[myodbc]
Driver = MySQL
Description = MySQL ODBC 2.50 Driver DSN
Server = localhost
Port =
User = root
Password =
Database = test
Option = 3
Socket =
[myodbc3]
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
Description = MySQL ODBC 3.51 Driver DSN
Server = localhost
Port =
User = root
Password = password
Database = ldap_test
Option = 3
Socket =
[Default]
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
Description = MySQL ODBC 3.51 Driver DSN
Server = localhost
Port =
User = root
Password = password
Database = ldap_test
Option = 3
Socket =
Both libmyodbc.so and libodbcmyS.so do exist in the correct directory. The database ldap_test is created and MySQL is running. I have not been able to find a solution to this problem by using Altavista, Google etc.
