From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.tools Subject: Re: using ProC to connect to a remote dbase (known via tsnames.ora)? Date: Fri, 2 Feb 2001 06:31:58 +0100 Message-ID: References: <95csg4$lhp$1@nnrp1.deja.com> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 X-Complaints-To: abuse@nl.demon.net NNTP-Posting-Host: sybrandb.demon.nl X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78 X-Trace: beta-news.demon.nl 981092063 beta-news:58585 NO-IDENT sybrandb.demon.nl:212.238.21.78 Lines: 34 Apparently your program is relying on an environment variable, most likely the LOCAL variable in HKLM\software\oracle or the TWO_TASK variable in Unix (you don't mention your platform). Try setting it appropiately and see whether it works: no modifications will be necessary. Otherwise, find the exec sql connect statement and change that into exec sql connect using ''. That should be all. Hth, Sybrand Bakker, Oracle DBA "cjvenron" wrote in message news:95csg4$lhp$1@nnrp1.deja.com... > i'm doing something ostensibly straightforward- compiling some of the > sample pro-c code on a machine with oracle client-side programmer's > option installed. > > like basically everyone else in the oracle world, our databases are > remote, and i know where they are thru the tsnames.ora file downloaded > to my server daily. > > but, this c-code only seems to support username/password connects, and > not those with remore hosts id's (ie, ip addresses and port numbers). > > does anyone know the (likely minor) modifications to make to the c code > (dynamic sql, fyi) to permit connections to remote hosts? > > > Sent via Deja.com > http://www.deja.com/