Re: ORACLE_SID and Windows NT

In article <70pcn6$2sg$1_at_jaydee.iway.fr>,   "Vincent Duret" <vduret_at_trivium.fr> wrote:
> Hello,
>
> A ProC software connects to an oracle database on a windows NT machine.
> The software and the database are running on the same machine. So SqlNet is
> not installed.
> For the moment, the software uses the registry key ORACLE_SID.
> It works fine because there is only one database running on the server.
> In the case of two databases the ORACLE_SID registry key points on one of
> the
> two databases at the same time.
>
> My question is :
> How can I do to make the software connect to the database without using the
> ORACLE_SID registry key ?
> If possible, a solution without installing SqlNet.
>
> Thanks
>
> -------------------------------------------------------------
> Vincent Duret (vduret_at_trivium.fr)
> TriVium - Les Arbres de Connaissances
> -------------------------------------------------------------
>
>

From DOS prompt:

set ORACLE_HOME=C:\orant (or something else) set ORACLE_SID=ORCL (or somthing else)

before running your Pro*C program (make sure that the program uses the above variables).

Xuening Sun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 23 1998 - 10:21:35 CDT