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

you can try to start the service with a user-logon, such as the one you use successfully when doing it manually........configure it where you config the service - in 'services' applet...

Sybrand Bakker wrote in message <35DF3EAD.5CF9E95C_at_sybrandb.demon.nl>...
>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 Mon Aug 24 1998 - 00:00:00 CDT