Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I Connect when running as an NT-Service?
I have used the format user/pass_at_whatever in the past (with SQLLDR).
This application connects using ODBC and the connect string
"DSN=;USER=;PWD=".
Where do I put the connect statement or the @whatever.
Thanks,
Don chambers_at_inquiregroup.com
On Thu, 20 Aug 1998 19:29:09 +0100, Steve Haynes <steve_at_rwx777.demon.co.uk> wrote:
>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 - 16:47:04 CDT