Running as service denies access to database

[Guy Cohen]

Hi all
I have a problem running my program as a service.
When it runs as a desktop program, it has access to oracle database.
When it runs as a service it returns an error:

Oracle client and networking components were not found. These components are
supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or
later client software installation.

Please advise
TIA
Guy Cohen

 

[Guest]

Hi all
I have a problem running my program as a service.
When it runs as a desktop program, it has access to oracle database.
When it runs as a service it returns an error:

Oracle client and networking components were not found. These
components are supplied by Oracle Corporation and are part of the
Oracle Version 7.3.3 or later client software installation.

Please advise

What account are you using to run your service? You may need an account
with elevated permissions.

Also, how are your authenticating against the Oracle database? Is it with
username/password or is it implicit through your active directory login?

 

[Guy Cohen]

Hi again,

The connection string is:
"Provider=MSDAORA.1;Password=PPP;User ID=UUU;Data Source=SSS;"
Where sss is the server name, uuu and ppp is the login info.

I tried to login with "local account"
also I put my credentials and the computer administrator credentials.
Non worked.
I verified that I have access to the directory where oracle home is (not on
my computer)

Question - how can I tell that I have oracle client installed ?(I cannot see
it under add/remove programs)

 

[Guy Cohen]

Update - the service is working fine now.

Is it possible that there was a timeout with oracle before?
I cannot find how to provide connection timeout - I googled some and
included that in the connection string (because the property is read only)
How do I do that otherwise ?

TIA
Guy Cohen