Urgent- Help cannot connect from oracle to MySql using Oracle Hetereogeneous generic connectivity agent
Date: 9 Jun 2003 07:58:11 -0700
Message-ID: <25c1993e.0306090658.5c2e94d9_at_posting.google.com>
Dear oracle gurus,
no body seem to reply to my earlier posting. I have problems
connecting to MySql server from oracle using dblinks and oracles
heterogeneous services generic connectivity agent. Iam using MyOdbc
3.5.1 driver from mysql.com
I am pasting below, the inithsodbc.ora,
ERROR at line 1:
inithsodbc.ora
tnsnames.ora
listener.ora,tnsnames.ora,odbc.ini and hs.log for reference
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Generic Connectivity Using ODBC]DRV_InitTdp: DB_ODBC_INTERFACE(6);
Initialization function SQLAllocConnect not found
DB_ODBC_INTERFACE(7); Cannot connect to shareable
/opt/odbc/MyODBC-3.51.06-sun-solaris2.8-sparc/libmyodbc3-3.51.06.so.
Using
dummy functions
ORA-02063: preceding 3 lines from HSODBC
# This is a sample agent init file that contains the HS parameters
that are
# needed for an ODBC Agent.
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = test
HS_FDS_TRACE_LEVEL = 4
HS_FDS_TRACE_FILE_NAME = /tmp/hs.log
HS_FDS_SHAREABLE_NAME = /usr/local/lib/libmyodbc3.so
#
# ODBC specific environment variables
#
set ODBCINI=/opt/odbc/MyODBC-3.51.06-sun-solaris2.8-sparc/odbc.ini
#
# Environment variables required for the non-Oracle system
#
set PATH=${PATH}:/opt/odbc/MyODBC-3.51.06-sun-solaris2.8-sparc:/usr/local/bin
set LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/local/lib
hsodbc = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=plexview1)(PORT=1521))
(CONNECT_DATA=(SID=test))
(HS=OK)
)
listener.ora
(SID_DESC=
(SID_NAME=test) (ORACLE_HOME=/opt/PlexView/Oracle/ora01/app/oracle/product/8.1.7) (PROGRAM=hsodbc)
)
ODBC.ini file
; ; odbc.ini configuration for MyODBC and MyODBC 3.51 Drivers ; setenv ODBCINI /opt/odbc/MyODBC-3.51.06-sun-solaris2.8-sparc/odbc.ini ; setenv ODBCSYSINI /opt/odbc/MyODBC-3.51.06-sun-solaris2.8-sparc ; setenv LD_LIBRARY_PATH ${LD_LIBRARY_PATH}:/usr/local/lib
[ODBC Data Sources]
myodbc = MySQL ODBC 2.50 Driver DSN myodbc3 = MySQL ODBC 3.51 Driver DSN test = MySQL ODBC 3.51 Driver DSN ++ tesths.log generated by teh driver
[myodbc]
Driver = /usr/local/lib/libmyodbc.so Description = MySQL ODBC 2.50 Driver DSN - PlexView1 SERVER = artemis PORT = 17000 USER = bilin Password = telica Database = test OPTION = 3 SOCKET =
[myodbc3]
Driver = /usr/local/lib/libmyodbc3.so Description = MySQL ODBC 3.51 Driver DSN SERVER = artemis PORT = 17000 USER = bilin Password = telica Database = test OPTION = 3 SOCKET =
[test]
Driver = /usr/local/lib/libmyodbc3.so Description = MySQL ODBC 2.50 Driver DSN - test SERVER = artemis PORT = 17000 USER = bilin Password = telica Database = test OPTION = 3 SOCKET =
[Default]
Driver = /usr/local/lib/libmyodbc3.so Description = MySQL ODBC 3.51 Driver DSN SERVER = artemis PORT = 17000 USER = bilin Password = telica Database = test OPTION = 3 SOCKET = -------------------------------------------------------------------------
MONDAY JUN 09 2003 10:02:20.694 hoagprd(2); Entered.
[Generic Connectivity Using ODBC] version: 2.0.4.0.0010
connect string is:
YEAR2000_POLICY=-1;CTL_DEBUG=T;CONSUMER_API=1;SESSION_BEHAVIOR_FLAGS=4;PARSER_- DEPTH=2000;EXEC_FLAGS =
131080;defTdpName=test;binding=(test,GENERIC_ODBC_FOR_HS,"test"); ORACLE GENERIC GATEWAY Log File Started at 09-Jun-03 10:02:20 Class version: 65
hoagprd(2); Exited with retcode = 0. hoainit(3); Entered. hoainit(3); Exited with retcode = 0. hoalgon(7); Entered. name = BILIN.
SYSTEM(2); ld.so.1: hsodbctest: fatal: libodbcinst.so.1: open failed: No such
file or directory
DB_ODBC_INTERFACE(6); Initialization function SQLAllocConnect not found
DB_ODBC_INTERFACE(7); Cannot connect to shareable /usr/local/lib/libmyodbc3.so. Using dummy functions DB_ODBC_INTERFACE(99); Initialization function SQLAllocConnect not found
DRV_InitTdp: DB_ODBC_INTERFACE(6); Initialization function SQLAllocConnect not
found
DB_ODBC_INTERFACE(7); Cannot connect to shareable /usr/local/lib/libmyodbc3.so. Using dummy functions
nvRETURN (drv_bind.c 187): -2220
nvRETURN (nav_bind.c 417): -2220
nvOUT (geterror.c 327): DRV_InitTdp: DB_ODBC_INTERFACE(6);
Initialization
function SQLAllocConnect not found
DB_ODBC_INTERFACE(7); Cannot connect to
shareable /usr/local/lib/libmyodbc3.so. Using dummy functions
hoalgon(7); Exited with retcode = 28500. hoaexit(6); Entered. hoaexit(6); Exited with retcode = 0.
Closing log file at MON JUN 9 10:02:20 2003.
- your help is greatly appreciated.
-thx,
avsrk
Received on Mon Jun 09 2003 - 16:58:11 CEST