Xref: alice comp.databases.oracle.misc:27059
Path: alice!news-feed.fnsi.net!netnews.com!cpk-news-hub1.bbnplanet.com!news.gtei.net!firehose.mindspring.com!not-for-mail
From: "dhmac" <dhmac@JUSTREMOVETHISmy-dejanews.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Does Pro*C use ODBC to connect to Oracle?
Date: Wed, 3 Mar 1999 22:49:41 -0500
Organization: MindSpring Enterprises
Lines: 25
Message-ID: <7bkvri$81c$1@camel21.mindspring.com>
References: <7bh7an$4no$1@nnrp1.dejanews.com>
X-Server-Date: 4 Mar 1999 03:49:06 GMT
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

flaggedatbest@yahoo.com wrote in message <7bh7an$4no$1@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.