Hi,

I have been trying to connect to a sybase 9 database through ODBC
using SQL Anywhere with no joy. I couldn't getthe LD_LIBRARY_Path to
be picked up and the correct .so files weren't found. I thought it
might be something to do with me running CentOS on the web server.

I have since tried FreeTDS via unixODBC, which worked, but I could not
CALL stored procedures through it. It just hang if I ran "{CALL
mr_proc(x,y,z);}" as a normal SQL query and I would get an error
saying i didn't have the rights to CREATE PROCEDURE if I ran the
odbc_prepare and odbc_connect functions.

I have also tried the sqlanywhere ODBC drivers, but everytime I get a
cannot open file error.

"Can't open lib '/opt/sqlanywhere12/lib64/libdbodbc12_r.so' :
libdbtasks12_r.so: cannot open shared object file: No such file or
directory,"

I have tried with _n and generic versions also. As well as the 32 bit
versions. Wrong ELF class.

Any help would be appreciated. I got as far as running queries fine
with FreeTDS, but could not run procedures. I can get no where with
the sybase stuff.