Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've just setup unixODBC with libmyodbc.

isql -v mydb Works perfect. I can run SELECT commands, updates etc. no worries. When I try to connect through my connector in bondijs I get this errorr:

([unixODBC][Driver Manager]Can't open lib '/usr/lib64/odbc/libmyodbc.so' : file not found)

I don't think it's something language specific, because I've seen a bunch of articles online about it, which explain that i need mysql.so (have it), ensure that lib64 is in use (it is) and show me how to test it using isql (it works). My connection string looks like this: DSN=mydb;

And I run it using this command env ODBCINI=/etc/odbc.ini ODBCSYSINI=/etc/ bondi pdf.esp (pdf.esp just contains the code var Db = new DbConnection("odbc:DSN=mydb");;

I'm on a 64bit Debian squeeze install.

Any Ideas? here's the files.

/etc/odbc.ini

[mydb]
Description = MySQL PDF eDelivery
Driver      = MySQL
SERVER      = localhost
UID         = myuser
USER        = myuser
PASSWORD    = password
PORT        = 3306
DATABASE    = mydb

/etc/odbcinst.ini

[MySQL]
Description             = MySQL driver for Linux & Win32
Driver          = /usr/lib64/odbc/libmyodbc.so
Setup           = /usr/lib64/odbc/libodbcmyS.so
FileUsage               = 1
UsageCount              = 1

Other

    galaxy:/home/# uname -m
    x86_64
    galaxy:/home/# uname -a
    Linux galaxy.com 2.6.18-194.26.1.el5xen #1 SMP Tue Nov 9 13:35:30 EST 2010 x86_64 GNU/Linux
ls /usr/lib64/odbc/libmyodbc.so
/usr/lib64/odbc/libmyodbc.so
share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.