Re: using ProC to connect to a remote dbase (known via tsnames.ora)?

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 '<servicename>'.

That should be all.

Hth,

Sybrand Bakker, Oracle DBA

"cjvenron" <cjvenron_at_my-deja.com> wrote in message news:95csg4$lhp$1_at_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/
Received on Fri Feb 02 2001 - 06:31:58 CET