[unixODBC-support] Could not find symbol 'SQLAllocConnect'

Buecker, Martin Martin.Buecker at t-systems.com
Thu Feb 8 11:31:18 GMT 2007

Hello Norman,

trying to read a table in the remote mysql db, I get the error:

SQL> select count(*) from cr_bemerkung at mysql;
select count(*) from cr_bemerkung at mysql
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][C078] Dynamic library
'/usr/local/lib/mylibodbc3.so' was not found
ORA-02063: preceding 2 lines from MYSQL

The library exists:
G8NY0:orapbn 1% cd /usr/local/lib
G8NY0:orapbn 2% ll *myodbc3*.so
-rw-r--r--   1 orapbn   dba       351196 Feb  2 08:26 libmyodbc3-3.51.06.so
lrwxrwxrwx   1 root     other         21 Feb  7 13:50 libmyodbc3.so -> libmyodbc3-3.51.06.so
-rw-r--r--   1 orapbn   dba       355564 Feb  2 08:26 libmyodbc3_r-3.51.06.so
lrwxrwxrwx   1 root     other         23 Feb  7 13:51 libmyodbc3_r.so -> libmyodbc3_r-3.51.06.so

HS_FDS_SHAREABLE_NAME = /usr/local/lib/libmyodbc3.so

# ODBC specific environment variables
set ODBCINI=/oracle/mysql/unixODBC/odbc.ini

entry in odbc.ini:
Driver          = /usr/local/lib/libmyodbc3.so

The connection with isql is working!

Thank you in advance for any help!

Martin Buecker

More information about the unixODBC-support mailing list