Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How do I Connect when running as an NT-Service?

How do I Connect when running as an NT-Service?

From: <inquire3_at_orion#mindspring.com>
Date: Thu, 20 Aug 1998 18:06:54 GMT
Message-ID: <35dc6257.64063828@orion>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US