Major ORA-12203 Grief

First I want to say any help is greatly appreciated!

Situation: We have an application that is written to connect to an Oracle 8i server using the 8.1.6.x.x Oracle ODBC Driver.

Our customer has an old in house app that uses the Oracle 7.3 ODBC Driver that connects to an 8i server.

What they woould like is for us (ME) to do is change our application to use the 7.3 Driver to connect to the server so that they can still use their old applications.

In the attempt of trying to do so, I've set up two Windows NT Servers to test wether or not we can in fact do this. The problem I'm running into is that while the server can connect to itself and function correctly with the 8.1.6 drivers then workstation receives the ORA-12203 error giving 'unable to connect to destination' error message.

I'm trying to connect with SQL Plus 3.3.3.0 on the workstation first to test the connection before hacking our app apart. I've tried connecting through the gui client as well as the command-line client.

I've been going through posts for the past three hours and am at my wits end. I've checked, double checked, and rechecked the double checked and everything seems to be configured correctly. If fact tnsping does pass, so I know the listener is running on the correct port (1521).

Also for kicks I've tried delete and recreating the db instance & listener

Can someone ANYONE Please help.

TIA,
Mike Received on Thu Jan 18 2001 - 05:40:19 CST