(I posted this earlier in Oracle9i Forum, but just saw this forum.)
We have a data link using HSODBC from our Oracle 9i server to an AS/400. The link is working fine on the Production db connection and used to work on the TEST server. Our Oracle TEST box crashed and we have rebuilt it. Now the link from TEST box to AS400 test libraries gives the following error:
SQL> desc hteusrt.splwf@spl_interface;
ERROR:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]
ORA-02063: preceding 2 lines from SPL_INTERFACE
************
I have verified parameters in "inithsodbc" in the HS folder. Also verified Listener.ora and TNSNames.ora file. Is anyone out there familiar with this type of connection to AS400? THANK YOU!
We have a data link using HSODBC from our Oracle 9i server to an AS/400. The link is working fine on the Production db connection and used to work on the TEST server. Our Oracle TEST box crashed and we have rebuilt it. Now the link from TEST box to AS400 test libraries gives the following error:
SQL> desc hteusrt.splwf@spl_interface;
ERROR:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]
ORA-02063: preceding 2 lines from SPL_INTERFACE
************
I have verified parameters in "inithsodbc" in the HS folder. Also verified Listener.ora and TNSNames.ora file. Is anyone out there familiar with this type of connection to AS400? THANK YOU!