LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   iODBC configuration problem (https://www.linuxquestions.org/questions/linux-software-2/iodbc-configuration-problem-791571/)

kja_007700 02-25-2010 03:09 PM

iODBC configuration problem
 
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.

s_110_z 09-19-2010 07:27 AM

Help on ODBC
 
Hi,

Today i got a problem with installing odbc on debian lenny & when i googling ,i understood that u had similar problem 8 month before !
So, Could you please let me know if u solved your problem & how did you do it ?


Regards


All times are GMT -5. The time now is 06:50 PM.