| in pro*c [message #178874] |
Fri, 23 June 2006 04:31  |
raom
Messages: 22
Registered: January 2006
Location: india
|
Junior Member |
|
|
how can u specify the database to login in pro*c
i have to databases on same machine with same username password but different SID .also they have same tables with minor changes
now
how can u specify the database to which to connect using SID in pro*c.
i did
export ORACLE_SID = xxxx but in vain.please suggest.
[Updated on: Fri, 23 June 2006 04:32] Report message to a moderator |
|
|
|
| Re: in pro*c [message #178898 is a reply to message #178874] |
Fri, 23 June 2006 05:59  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Example from the Pro*C/C++ Programmer's Guide:
/* declare needed host variables */
char username[10] = "scott";
char password[10] = "tiger";
char db_string[20] = "NYNON";
/* give the database connection a unique name */
EXEC SQL DECLARE DB_NAME DATABASE;
/* connect to the nondefault database */
EXEC SQL CONNECT :username IDENTIFIED BY :password
AT DB_NAME USING :db_string; |
|
|
|
| Re: in pro*c [message #178902 is a reply to message #178898] |
Fri, 23 June 2006 06:15 |
raom
Messages: 22
Registered: January 2006
Location: india
|
Junior Member |
|
|
thanks for the reply
i donno if i understand that.let me elaborate
i have a user guna/guna with SID PQR
one more user guna/guna with SID KML
where KML is default but i dont want to connect to default one.
what can i do.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
