Re: OCI - Connecting to Database

Harish,
I looks like users SYSTEM and U02IB94 do have different idea where to look for TNSNames.ORA.
In RegEdit check for value ORACLE_HOME

    it should be in HKEY_LOCAL_MACHINE
    not in HKEY_CURRENT_USER.
Other thing : check your PATH . is ORANT\BIN in system path or only user path.
I'll have to ask our network and NT gays. I think I do remember that there are some special settings for user SYSTEM.

Send me an email . I may have some more answers tomorrow. (Friday that is)

Thomas Olszewicki
ThomasO_at_cpas.com
www.cpas.com

"Harish" <hdeshpandeNOhdSPAM_at_carlson.com.invalid> wrote in message news:17599f0b.77cac0aa_at_usw-ex0107-042.remarq.com...
> Thomas,
>
> Thanks for your response.
>
> I am connecting to the database as 'username/password_at_dbname' where
> dbname is an entry in 'tnsnames.ora'. As an NT application there is no
> problem with this. However when I convert this to an NT service I get
> connected to a different database. The 'dbname' is not being used as
> whatever name I use I get connected to the same database.
>
> I have checked the listener log on the server. The connect string
> when I run the same as an application is as follows:
>
> 06-JAN-00 16:26:41 *
> (CONNECT_DATA=(SID=t09ubk)(CID=(PROGRAM=C:\Harish\CMG-Award
> s\VRU\NewDesign\NT\vru_wa.exe)(HOST=W150807)(USER=U02IB94))) *
> (ADDRESS=(PROTOCO
> L=tcp)(HOST=172.26.67.131)(PORT=1915)) * establish * t09ubk * 0
>
> and log when I run the same as a service is as follows:
>
> 06-JAN-00 16:08:01 *
> (CONNECT_DATA=(SID=*)(SERVICE_NAME=t09ubk)(CID=(PROGRAM=C:\
>

Harish\CMG-Awards\VRU\NewDesign\Samplesvc\vsimple.exe)(HOST=W150807)(USER=SY STEM
> ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.26.67.131)(PORT=1894)) *
> establish * t09ubk * 0
>
> For some reason the 'olog' call( I am using version 7.3.4 ) is not
> referring to the 'tnsnames.ora'. As a result the SID field above has
> '*'. Hope you are someone can tell me what is going on.
>
> Thanks again and good day.
>
> Harish
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu Jan 06 2000 - 22:15:50 CST