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

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


Hi,

additional information in the trace file:

Oracle Corporation --- THURSDAY  FEB 08 2007 12:37:42.654

    Version 9.2.0.5.0

hoagprd (2): ; hoagprd Entered.
 (0): ; [Generic Connectivity Using ODBC] version: 3.3.00.00.0037
 (0): ; Class version: 128
hoagprd (2): ; hoagprd Exited with retcode = 0.
hoainit (3): ; hoainit Entered.
 (0): ; connect string is: defTdpName=mysql;SYNTAX=(ORACLE8_HOA,
BASED_ON=ORACLE8, IDENTIFIER_QUOTE_CHAR="",
CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=<navobj>
<binding>
<datasources>
<datasource name='mysql' type='GENERIC_ODBC_FOR_HS' connect='mysql'>
<driverProperties/></datasource></datasources><remoteMachines/><environment>
<misc year2000Policy='-1' consumerApi='1' sessionBehavior='4'/><queryProcessor
parserDepth='2000' noInsertParameterization='true' noThreadedReadAhead='true'
noCommandReuse='true'/><debug driverTrace='true'
generalTrace='true'/></environment></binding></navobj>
ORACLE GENERIC GATEWAY Log File Started at 08-Feb-07 12:37:42
hoainit (3): ; hoainit Exited with retcode = 0.
hoalgon (7): ; hoalgon Entered. name = dfmg.
sysbase.c (668): ; ld.so.1: hsodbc: fatal: /usr/lib/sparcv9/libodbcinst.so.1:
wrong ELF class: ELFCLASS64
DB_ODBC_INTERFACE (713): ; [C077] Could not find symbol 'SQLAllocConnect' in
dynamic library
DB_ODBC_INTERFACE (717): ; [C079] Failed to load dynamic library
'/usr/local/lib/libmyodbc3.so'
DB_ODBC_INTERFACE (722): ; [C077] Could not find symbol 'SQLAllocConnect' in
dynamic library
DRV_InitTdp: DB_ODBC_INTERFACE (713): ; [C077] Could not find symbol
'SQLAllocConnect' in dynamic library
DB_ODBC_INTERFACE (717): ; [C079] Failed
to load dynamic library '/usr/local/lib/libmyodbc3.so'

nvRETURN (./drv_bind.c 201): -2220
nvRETURN (./nav_bind.c 456): -2220
hoalgon (7): ; hoalgon Exited with retcode = 28500.
hoaexit (6): ; hoaexit Entered.
Hoaexit (6): ; hoaexit Exited with retcode = 0.
 (0): ; Closing log file at THU FEB  8 12:37:42 2007.

Regards and thanks

Martin

-----Ursprüngliche Nachricht-----
Von: Bücker, Martin 
Gesendet: Donnerstag, 8. Februar 2007 12:31
An: unixodbc-support at easysoft.com
Betreff: [unixODBC-support] Could not find symbol 'SQLAllocConnect'


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-Parameters:
HS_FDS_CONNECT_INFO = mysql
HS_FDS_TRACE_LEVEL = off
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

_______________________________________________
unixODBC-support mailing list
unixODBC-support at easysoft.com
http://mail.easysoft.com/mailman/listinfo/unixodbc-support




More information about the unixODBC-support mailing list