Connect to DB2 using Generic Connectivity

[debaditya]

Hi ,

I am trying to configure generic Connectivity and I am using 3rd party ODBC from Merant. My Oracle ( 8.1.6) is in a SOlaris 2.6 box and the DB2 is in a Windows 2000 box . After configuring the odbc.ini and the HS parameters in the configuration file , I always end up getting the following error .

ERROR at line 1:
ORA-00942: table or view does not exist
[Transparent gateway for ODBC]DRV_OpenTable: [MERANT][ODBC DB2 driver][DB2]L805
PROGRAM NAME 'GMD_DBMS.DefaultA' NOT FOUND IN PLAN '' (SQL State: S1000; SQL
Code: -805)
ORA-02063: preceding 2 lines from DB2

I have another Oracle 8.1.6 installation on Windows 2000, I can connect to the DB2 server from this windows box .

Thanks

Debaditya

[debaditya]

The problem was with the length of the package name in the odbc.ini file . It should not be more than 6 characters long .

Building the package , solved the problem.