Re: Oracle ODBC Connectivity

From: Justin Cave <jocave_at_yahoo.com>
Date: 7 Oct 2002 12:54:56 -0700
Message-ID: <233b7a65.0210071154.6171c8a@posting.google.com>

vkapadia_at_hotmail.com (Vipul Kapadia) wrote in message news:<997d4176.0210042313.357cba92_at_posting.google.com>...
>
> I am facing a problem with conecting to Oracle on Win 2000 Server using ODBC.
> The Oracle DB is up and running and I can connect to it using SQL Plus,
> but when I try to connect to ODBC using the "ODBC Test" client, the
> test client itself hangs up.

Can you define "hangs up"? Are you getting an error message? If so, what's the message?

Which ODBC driver are you trying to use? If you're using the latest version of the Oracle driver, you should have a "Test ODBC Connection" button when you create a DSN. What happens when you try to test your connection here?

Can you tnsping the tns name you're supplying to the ODBC driver?

Justin Cave

>
> Im using Oracle 8.1.5.
>
> Also tried connecting using VC++ application, but similarly the application
> just hangs while establishing the connection.
>
> What could the problem be ?
>
> Regards
> Vipul Kapadia
Received on Mon Oct 07 2002 - 14:54:56 CDT