Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How do I Connect when running as an NT-Service?
I have a program which needs to run as an NT service. This program
works fine when run manually but when run as a service it cannot
connect to the database.
I think I may need to set environmental variables in the program but I
do not know which ones. I have tried ORACLE_SID and ORACLE_HOME. If
I type set at the command prompt I do no see any ORACLE variables.
Below is a the error message returned:
ORA-12203: TNS:unable to connect to destination
Driver's SQLSetConnectAttr failed
Error is State:S1000,Native:12203,Origin:[Oracle][ODBC][Ora]
State:IM006,Native:0,Origin:[Microsoft][ODBC Driver Manager]
Received on Thu Aug 20 1998 - 13:06:54 CDT
![]() |
![]() |