470,573 Members | 1,763 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,573 developers. It's quick & easy.

Running as service denies access to database

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

Jan 13 '08 #1
3 1118
=?Utf-8?B?R3V5IENvaGVu?= <Gu******@discussions.microsoft.comwrote in
news:98**********************************@microsof t.com:
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?

--
sp**********@rogers.com (Do not e-mail)
Jan 14 '08 #2
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)

"Spam Catcher" wrote:
=?Utf-8?B?R3V5IENvaGVu?= <Gu******@discussions.microsoft.comwrote in
news:98**********************************@microsof t.com:
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?

--
sp**********@rogers.com (Do not e-mail)
Jan 14 '08 #3
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

"Guy Cohen" wrote:
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)

"Spam Catcher" wrote:
=?Utf-8?B?R3V5IENvaGVu?= <Gu******@discussions.microsoft.comwrote in
news:98**********************************@microsof t.com:
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?

--
sp**********@rogers.com (Do not e-mail)
Jan 14 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Mike S. Nowostawsky | last post: by
5 posts views Thread by Chris Dugan | last post: by
2 posts views Thread by axel22 | last post: by
reply views Thread by =?Utf-8?B?RmlsaXBwbyBCZXR0aW5hZ2xpbw==?= | last post: by
11 posts views Thread by John Sheppard | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.