Home » Developer & Programmer » Precompilers, OCI & OCCI » How to build a connection string in Pro*C
How to build a connection string in Pro*C [message #94238] Wed, 02 June 2004 03:33 Go to next message
puneet
Messages: 76
Registered: August 2002
Member
How can i build a connection string in Pro*c

EXEC SQL CONNECT :Username IDENTIFIED BY :Userpass AT DB_NAME USING :DBname;

 

wat should i supply in DBname ..suppose if the database name is ABC and server name is def on which it is lying!!!
Re: How to build a connection string in Pro*C [message #94239 is a reply to message #94238] Wed, 02 June 2004 06:25 Go to previous message
Kaustubh Deshpande
Messages: 32
Registered: March 2004
Member
Dear Friend,

You can also connect by this way.

Construct VARCHAR string like this username/passwd@server_name

server_name you will find in tnsnames.ora.

After constructing string , just say

EXEC SQL CONNECT :connectstring ;

That's it

regards,
Kaustubh
Previous Topic: Wanted ACUCOBOL Software
Next Topic: Urgent Help - Coredump
Goto Forum:
  


Current Time: Fri Mar 29 02:41:28 CDT 2024