Oracle Database Discussions

Hi,

I am facing the following problems while connecting to AS400 database. I have read the documentation and set the listener and tnsnames properly.
I believe this, because I can connect to MS Access database using similar set up.

The error message displayed on the SQL prompt:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]DRV_InitTdp: [IBM][Client Access ODBC Driver
(32-bit)][DB2/400 SQL]Communication link failure. COMM RC=0x5 (SQL State: 08S01; SQL Code: -5)
ORA-02063: preceding 2 lines from AS400

The trace file gives me output like

Oracle Corporation --- TUESDAY APR 23 2002 16:46:12.188

Version 9.0.1.1.1

(0) hoagprd(2); Entered.
(0) [Generic Connectivity Using ODBC] version: 2.0.4.0.0030
(0) connect string is:
(0)
YEAR2000_POLICY=-1;CTL_DEBUG=T;CONSUMER_API=1;SESSION_BEHAVIOR_FLAGS=4;PARSE
R_-
(0) DEPTH=2000;EXEC_FLAGS =
131592;defTdpName=AS400;binding=(AS400,ODBC,"AS400");
(0) ORACLE GENERIC GATEWAY Log File Started at 23-Apr-02 16:46:12
(0) Class version: 105
(0) hoagprd(2); Exited with retcode = 0.
(0) hoainit(3); Entered.
(0) hoainit(3); Exited with retcode = 0.
(0) hoalgon(7); Entered. name = SYSTEM.
(0) [IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]Communication link
(0) failure. COMM RC=0x5 (SQL State: 08S01; SQL Code: -5)
(0) DRV_InitTdp: [IBM][Client Access ODBC Driver (32-bit)][DB2/400
(0) SQL]Communication link failure. COMM RC=0x5 (SQL State: 08S01; SQL Code: -5)
(0)
(0) nvRETURN (P:\Src\DRV\DRV_BIND.C 324): -2220
(0) nvRETURN (P:\Src\NAV_BIND.C 417): -2220
(0) nvOUT (P:\Src\UTIL\GETERROR.C 327): DRV_InitTdp: [IBM][Client Access ODBC
(0) Driver (32-bit)][DB2/400 SQL]Communication link failure. COMM RC=0x5
(SQL
(0) State: 08S01; SQL Code: -5)
(0) hoalgon(7); Exited with retcode = 28500.
(0) hoaexit(6); Entered.
(0) hoaexit(6); Exited with retcode = 0.
(0) Closing log file at TUE APR 23 16:46:16 2002.

I assme that ODBC driver used over here is complint to the requirements, as fellow forum members are using same ODBC driver successfully.

To test the ODBC connection I created blank MS Acees database. Using the odbc I could link the AS400 tables using the same ODBC driver. Here it shows me the data.

Using the web info, I have checcked following things as well
- QUSER profile is set with no user password.
- SRRSBS QSERVER shows active
- WRKSBSJOB QSERVER shows QZDAINIT QSERVER PJ ACTIVE along with other sub services.

There is a possible hitch that driver never prompts me for user id /password where as it does while using as400 tables.from Access.

Please help.

Regards,

Hemant