Re: HELP!- Question and Problem in connecting to remote Oracle database using PRO*C

On Mon, 19 Jul 2004 10:29:28 +0800, Ursula Lee wrote:

> Hi,
>
> I am unable to connect to Oracle database from another server using
> Client/Server relationship.
>
> (FYI...Program is written as Pro*C using Oracle 9.2.0.1.0 running on
> UNIX HP-UX11)
>
> In my Pro*C program, I am using syntax as follows:
>
> EXEC SQL CONNECT :username IDENTIFIED BY :password AT :db_name USING
> :db_string;
>
> (Client Server: THS_1
> Database Server: THSORACLE
> Database Instance: DRLDBMS
> TNSNAMES defined on Client Server: DRLDBMS_THSORACLE
> )
>
> I have 2 instances running on THS_ORACLE, but I made the
> ORACLE_SID = DRLDBMS, ie. the instance I need to connect.
>
> So for the above connection, I am using:
>
> EXEC SQL CONNECT :username IDENTIFIED BY :password AT 'DRLDBMS' USING
> 'DRLDBMS_THSORACLE'
>
> But it is still failed in connection.

This is the right syntax:

EXEC SQL CONNECT :username IDENTIFIED BY :password AT 'DRLDBMS_THSORACLE'

The USING part should be used if and only if you plan on identifying database through the program. It is supposed to contain the full TNS description of the database, starting with (ADDRESS_LIST=...).

-- 
A city is a large community where people are lonesome together.