Urgent- Help cannot connect from oracle to MySql using Oracle Hetereogeneous generic connectivity agent

From: Subrahmanyam Arya <avsrk_at_mailcity.com>
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,
listener.ora,tnsnames.ora,odbc.ini and hs.log for reference

ERROR at line 1:
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

inithsodbc.ora



# 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

tnsnames.ora



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 ++ test



[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 = -------------------------------------------------------------------------
hs.log generated by teh driver

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

Original text of this message