Question about connection to Oracle database in another Server

[Turkbear]

Ursula Lee <ursula.lee@thales-is.com> wrote:
Hi,(FYI.. Oracle 9.2.0.1.0 running on HP-UX11)I have a Oracle Pro*C program used for loading data file into Oracledatabase. This program is running on DBMS (with Oracle database) servercurrently, but we plan to move our database into another server.So the enhancement will be : Pro*C program running on Server A, andOracle database running on Server B.With this set up, I believe remote database connection string will help. Please confirm.My current Pro*C structure has syntax like:EXEC SQL CONNECT :username IDENTIFIED BY :password;And after the change, should I use the syntax like:EXEC SQL CONNECT :username IDENTIFIED BY :password at :db_name using:db_string;If yes, can you please tell me what the 'AT' parameter and 'USING'parameter is for ?I am wondering where we have to give the machine name, database name,protocol to use to connect, and IP, port etc??The machine name on which i am working (with Pro*C) is PBL1 and i amtrying to connect to the remote database in DBMS, the database name isPBLDBMS.P.S. I believe this has nothing related to DB Link, correct?

Correct...Database Links are used for database to database communication..

What you will have is a fairly standard Client/Server relationship ( even though the client is a server)..

Install the correct version of the Oracle client on PBL1 and, in its tnsnames.ora file add an entry for
the Oracle instance .

hth

[Ursula Lee]

But am I using the correct statement for remote connection in Pro*C?

EXEC SQL CONNECT :username IDENTIFIED BY :password at :db_name using
:db_string;

If yes, can you please tell me what the 'AT' parameter and 'USING'
parameter is for ?

I am wondering where we have to give the machine name, database name,
protocol to use to connect, and IP, port etc??

Turkbear wrote: Ursula Lee <ursula.lee@thales-is.com> wrote:Hi,(FYI.. Oracle 9.2.0.1.0 running on HP-UX11)I have a Oracle Pro*C program used for loading data file into Oracledatabase. This program is running on DBMS (with Oracle database) servercurrently, but we plan to move our database into another server.So the enhancement will be : Pro*C program running on Server A, andOracle database running on Server B.With this set up, I believe remote database connection string will help. Please confirm.My current Pro*C structure has syntax like:EXEC SQL CONNECT :username IDENTIFIED BY :password;And after the change, should I use the syntax like:EXEC SQL CONNECT :username IDENTIFIED BY :password at :db_name using:db_string;If yes, can you please tell me what the 'AT' parameter and 'USING'parameter is for ?I am wondering where we have to give the machine name, database name,protocol to use to connect, and IP, port etc??The machine name on which i am working (with Pro*C) is PBL1 and i amtrying to connect to the remote database in DBMS, the database name isPBLDBMS.P.S. I believe this has nothing related to DB Link, correct? Correct...Database Links are used for database to database communication.. What you will have is a fairly standard Client/Server relationship ( even though the client is a server).. Install the correct version of the Oracle client on PBL1 and, in its tnsnames.ora file add an entry for the Oracle instance . hth

[Turkbear]

Hi,
Hi,
Maybe I'm confused ( not a rare thing) but that statement ( on further reflection) does not look like a ProC statement,
rather a PL/Sql one..

I see nothing in the ProC docs about using that construction.


Ursula Lee <ursula.lee@thales-is.com> wrote:
But am I using the correct statement for remote connection in Pro*C?EXEC SQL CONNECT :username IDENTIFIED BY :password at :db_name using:db_string;If yes, can you please tell me what the 'AT' parameter and 'USING'parameter is for ?I am wondering where we have to give the machine name, database name,protocol to use to connect, and IP, port etc??Turkbear wrote: Ursula Lee <ursula.lee@thales-is.com> wrote:Hi,(FYI.. Oracle 9.2.0.1.0 running on HP-UX11)I have a Oracle Pro*C program used for loading data file into Oracledatabase. This program is running on DBMS (with Oracle database) servercurrently, but we plan to move our database into another server.So the enhancement will be : Pro*C program running on Server A, andOracle database running on Server B.With this set up, I believe remote database connection string will help. Please confirm.My current Pro*C structure has syntax like:EXEC SQL CONNECT :username IDENTIFIED BY :password;And after the change, should I use the syntax like:EXEC SQL CONNECT :username IDENTIFIED BY :password at :db_name using:db_string;If yes, can you please tell me what the 'AT' parameter and 'USING'parameter is for ?I am wondering where we have to give the machine name, database name,protocol to use to connect, and IP, port etc??The machine name on which i am working (with Pro*C) is PBL1 and i amtrying to connect to the remote database in DBMS, the database name isPBLDBMS.P.S. I believe this has nothing related to DB Link, correct? Correct...Database Links are used for database to database communication.. What you will have is a fairly standard Client/Server relationship ( even though the client is a server).. Install the correct version of the Oracle client on PBL1 and, in its tnsnames.ora file add an entry for the Oracle instance . hth