Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Does Pro*C use ODBC to connect to Oracle?

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

From: dhmac <dhmac_at_JUSTREMOVETHISmy-dejanews.com>
Date: Wed, 3 Mar 1999 22:49:41 -0500
Message-ID: <7bkvri$81c$1@camel21.mindspring.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US