Re: Pro*c communication to database across machines
Date: 1995/08/31
Message-ID: <4259vi$1ca_at_inet-nntp-gw-1.us.oracle.com>#1/1
In article <DE6v4A.KA_at_nntpa.cb.att.com>, klang_at_hostara.att.com (Ken Lang) writes:
|> Hello. A recent project I've been assigned to requires that I write a
|> Pro*C program that runs on one HP-UX machine and accesses a database on
|> another HP-UX machine. Given that SQL*Net is running on both machines, is
|> this viable ? Are there SQL*NET library calls I can use in my PRO*C
|> program to access the remote database ?
|>
|> I appreciate any help.
|>
|> Thanks,
|>
|> Ken
|> klang_at_hostare.att.com
|>
This is very easy to do. All you need is a USING clause on the connect
statement, with a valid SQL*Net string. For example:
EXEC SQL CONNECT :username IDENTIFIED BY :password USING :sqlnet_string; Received on Thu Aug 31 1995 - 00:00:00 CEST