Help please- Heterogenous services suing General Connectivity agent

From: Subrahmanyam Arya <avsrk_at_mailcity.com>
Date: 6 Jun 2003 14:25:26 -0700
Message-ID: <25c1993e.0306061325.7d23bd78_at_posting.google.com>

Dear oracle gurus,

I am trying to create a public database link from oracle to mysql and using HS-general connectivity agent. I am using MYODBC driver from mysql. I got the odbctest to work properly. I cannot do a select * from <remotetable>_at_<dblink>

I paste below all teh error message i get as well as the inithsodbc.ora,tnsnames.ora,listener.ora configurations

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 = myodbc3
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=hsodbc))
            (HS=OK)
          )

listener.ora

---

  (SID_DESC=

      (SID_NAME=hsodbc)
      (ORACLE_HOME=/opt/PlexView/Oracle/ora01/app/oracle/product/8.1.7)
      (PROGRAM=hsodbc)

    )

• your help is greatly appreciated. thx, avsrk

Received on Fri Jun 06 2003 - 23:25:26 CEST