Re: Apache & Oracle on NT 4.0

In article <94t5lg$pnd$1_at_nnrp1.deja.com>,

        Vince Law <law_vince_at_my-deja.com> writes:

> I wrote a javabean and when I ran it as a standalone app, the
> connection through OCI to the Oracle DB is perfectly fine, but when I
> ran it behind the Apache WebServer, it then kept saying that "can not
> resolve the tns service name". I already checked the whole computer to
> make sure that there is only one tnsnames.ora file exists. I guess, it
> must be that I need to set some where to tell the Apache where to find
> the tnsnames.ora file. Any idea which file I need to set or any
> environment variable? By the way, I am using NT 4.0.

Assuming the Unix version is similar to NT, you need to set up the SQLNET.ORA / TNSNAMES.ORA in the Oracle Home where IAS is installed, probably $ORACLE_HOME\network\admin\*.ora.

-- 
Regards,

Richard