oracle to db2 via ODBC....

From: Eric <fast_johnnyz_at_yahoo.com>
Date: 8 Apr 2002 21:04:11 -0700
Message-ID: <2bb94f94.0204082004.1c2bae22@posting.google.com>

Strange, I can't seem to see any tables. Anyone ever had this problem?
Looking at the trace file, it looks like it can't login. (hoalgon(7); Exited with retcode = 28500) but what do I know....

select count(*) from db2filename.tablename_at_shbs840a.world

                                                  *

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]DRV_InitTdp:

ORA-02063: preceding 2 lines from CVGS840A.WORLD
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

hs trace file:
MONDAY APR 08 2002 21:56:03.818
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=CVGS840A;binding=(SHBS840A,GENERIC_ODBC_FOR_HS,"SHBS840A"); ORACLE GENERIC GATEWAY Log File Started at 08-Apr-02 21:56:03 Class version: 65

hoagprd(2); Exited with retcode = 0.
hoainit(3); Entered.
hoainit(3); Exited with retcode = 0.
hoalgon(7); Entered. name = testing.

DRV_InitTdp:

nvRETURN (drv_bind.c 324): -2220
nvRETURN (nav_bind.c 417): -2220
nvOUT (geterror.c 327): DRV_InitTdp:

hoalgon(7); Exited with retcode = 28500.
hoaexit(6); Entered.
hoaexit(6); Exited with retcode = 0.

Closing log file at MON APR 8 21:56:03 2002

Thanks, in advance, Received on Mon Apr 08 2002 - 23:04:11 CDT