Re: Does Pro*C use ODBC to connect to Oracle?

[Quoted] Make sure you pass user/password_at_<exactly_what_you_put_in_SQLNET>

12203 means your connect string you passed cannot be found.

Depending on which version of oracle client you have installed, you would have used sql*net Easy config or Net8 to set up an alias pointing to your db [Quoted] (which has the SID, TCP hostname etc).

You must have one setup for your odbc DSN that you set up, look at the details of that and depending on which version of ODBC Oracle driver you have it will either be called <server> or <service Name> or <sql*net connect string>

cheers ali...
[Quoted] flaggedatbest_at_yahoo.com wrote in message <7bh7b3$4nt$1_at_nnrp1.dejanews.com>...
>Hi
>
>I am having trouble getting started using Pro*C ver 8 and Visual C++ Ver 5.
>
>My Oracle database server is on hpux but I have ODBC running and regularly
>use VB to access that database with no connect problems.
>
>When I compile my Pro*C applications with MS Visual C++, my sqlnet.log
>fills up with repeated TNS Failures (12203,12560,102)
>
>In my userid/password string I try including the _at_host.domain.zone to
>no avail.
>
>Any help appreciated!!!
>
>-Dan
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Mar 12 1999 - 11:08:36 CET