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 -> Re: How do I Connect when running as an NT-Service?

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

From: Steve Haynes <steve_at_rwx777.demon.co.uk>
Date: Thu, 20 Aug 1998 19:29:09 +0100
Message-ID: <WGUcdTA1rG31EwWA@rwx777.demon.co.uk>


In article <35dc6257.64063828_at_orion>, inquire3_at_orion#mindspring.com writes
>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]
connect user/pass_at_whatever
You need the @whatever
Steve
--
"The floggings will continue until morale improves." Received on Thu Aug 20 1998 - 13:29:09 CDT

Original text of this message

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