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

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.