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

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