Re: Can't Connect to Oracle as NT service - can manually.

Try setting TNS_ADMIN as an environment variable or put it in the registry. TNS_ADMIN usually points to <ORACLE_HOME>\network\admin. Error message states the database is not running, this is probably untrue, and we are looking at a crippled sqlnet config. If this doesn't resolve it verify your sqlnet.ora and tnsnames.ora in your TNS_ADMIN directory is correct. If this doesn't resolve it make sure put TRACE_LEVEL_CLIENT = 16 in sqlnet.ora. This will give more specific error messages in a trace file (by default either in the directory the app is running or in <ORACLE_HOME>\network\trace.

Hth,
Sybrand Bakker

chambers_at_inquiregroup.com wrote:

> I have deleoped an app using Visual C++ which connects to an Oracle8
> server using ODBC. I connect to the database using the CDatabase
> object. When I run the application manually I have no problems. When
> run as an NT service I cannot connect to the database.
>
> I can make the app pop up the ODBC connection window and chose the
> driver here. Using this method I connect when running manually be
> still cannot connect when running as a service
>
> I think the problem my be related to env variables (the service does
> not login). I have tried setting ORACLE_HOME and the path to the
> oracle directory. Oracle home is set to the location the client
> software was installed. The actuall server is on another machine.
>
> Below is info from my log file. Using getenvvariable I print the
> actuall values of the environment variables. The rest of the error
> comes from the ODBC driver.
>
> ORACLE_HOME is e:\orant
> PATH is e:\orant
> ORA-12203: TNS:unable to connect to destination
>
> Driver's SQLSetConnectAttr failed
>
> S1000,Native:12203,Origin:[Oracle][ODBC][Ora]
> State:IM006,Native:0,Origin:[Microsoft][ODBC Driver Manager]
>
> Thanks,
> Don
> chambers_at_inquiregroup.com
Received on Sat Aug 22 1998 - 00:00:00 CDT