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
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 .