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

From: jacob <bogers_at_kpn-telecom.nl>
Date: 16 Mar 1999 10:16:52 GMT
Message-ID: <01be6f96$1d308850$ec1b1dac_at_ut9811251830>


NO,
It is not ODBC but OCI (oracle call interface) u must have de ociw32.dll installed!!
(using OCI u will be able to fetch twice as fast)

Ali King <ali.king_at_webbins.co.uk> schreef in artikel <7cap37$sbu$1_at_fire-3.webbins.co.uk>...
> 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
> (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...
> 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 Tue Mar 16 1999 - 11:16:52 CET

Original text of this message