Re: How to connect via Net8 in Pro*C program?

kirk_at_kaybee.org wrote:
>
> I can sucessfully run the following on the command line:
>
> sqlplus user/pass_at_tweb
>
> as "tweb" is defined in tnsnames.ora as a certain database on a certain
> host.
>
> However, I can't figure out how to utilize this Net8 Name from inside my
> Pro*C program.
>
> Can anybody offer any help?
>
> --
> Kirk Bauer -- CmpE, Georgia Tech -- kirk_at_kaybee.org -- Avid Linux User
> GT Sport Parachuting Club! http://cyberbuzz.gatech.edu/skydive
> Opinions expressed are my own, but they should be everybody's.

The following should work, if <connectStr> is your connect string "user/pass_at_tweb" from above:

  EXEC SQL CONNECT :connectStr;

Yours,

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Thu Mar 16 2000 - 22:56:26 CST