Windows XP DAO Error

[nbahari]

i have this "serviced" application written in VB and having problem to connect to db (oracle via odbc) when starting using local system account. however when starting the application using domain administrator ID, it is ok.

error as following:
ODBC -- connection to "XXX" failed.DAO.Workspace.

have checked the related permission SYSTEM a/c do hv sufficient access (incl in registry). anything i missed out?

 

[Techy]

if the DB is on a server and the servers a member of the domain, then you'll have to use a domain account. end of.

 

[nbahari]

this stmt is not really true as the same didnt happen in my test environment (ie in my test server, i start the same application-service using local sys a/c which the db is at different server). connection to the db is via odbc.