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

avsrk_at_mailcity.com (Subrahmanyam Arya) wrote in message news:<25c1993e.0306090658.5c2e94d9_at_posting.google.com>...

If you have access to http://metalink.oracle.com then read docid 150458.1

Regards
/Rauf Sarwar

> 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 Wed Jun 11 2003 - 22:59:16 CEST