Home -> Usenet -> comp.databases.oracle -> Explicit Connections in Pro*C

Explicit Connections in Pro*C

From: Will Jones <wjones14_at_explorer.csc.com>
Date: 1996/05/09
Message-ID: <Pine.SUN.3.91.960509153654.26663A-100000_at_explorer.csc.com>#1/1 








        We have a C program with embedded SQL developed with Pro*C.  We 
also have multiple instances of Oracle on our server.  If the user has 
his ORACLE_SID environmental variable set to the correct instance, the 
program connects and works fine.  If not, he gets an "Oracle not 
available" message and no connection.



        Our current connect statement is like:



EXEC SQL CONNECT :username IDENTIFIED BY :password;



where the user is prompted for the Oracle logon ID and password.  Can the 
instance of Oracle be specified here as well?



--
Bill Jones			e-mail addresses:
Computer Sciences Corp.			(work)	wjones14_at_csc.com
Norwich, Connecticut			(play)	billj_at_mindport.net
(203) 823-2168


Received on Thu May 09 1996 - 00:00:00 CEST












Original text of this message