Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Does Pro*C use ODBC to connect to Oracle?
flaggedatbest_at_yahoo.com wrote in message <7bh7an$4no$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 @host.domain.zone to
>no avail.
>
>Any help appreciated!!!
>
>-Dan
>
OCI doesn't use ODBC, but ODBC does use OCI. If you want to use ODBC, You'll
have rewrite your applications - dumping Pro*C and use ODBC calls instead (by
using the CRecordset in MFC, if I remember correctly). But the easier approach
is to keep your applications as they are and check out your SQL*Net
configuration, chances are there's something wrong there.
Received on Wed Mar 03 1999 - 21:49:41 CST