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