Re: Major ORA-12203 Grief

Mike,

Had the same issue with the MS ODBC for Oracle driver 2.5.73.

The ODBC driver requires SQL*Net rather than Net8.

I installed SQL*Net and all works fine.

I think there must be a better workaround..

Chris

Mike wrote:
>
> 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:54:16 CST