473,799 Members | 3,009 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1217
=?Utf-8?B?R3V5IENvaGV u?= <Gu******@discu ssions.microsof t.comwrote in
news:98******** *************** ***********@mic rosoft.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**********@ro gers.com (Do not e-mail)
Jan 14 '08 #2
Hi again,

The connection string is:
"Provider=MSDAO RA.1;Password=P PP;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?R3V5IENvaGV u?= <Gu******@discu ssions.microsof t.comwrote in
news:98******** *************** ***********@mic rosoft.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**********@ro gers.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=MSDAO RA.1;Password=P PP;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?R3V5IENvaGV u?= <Gu******@discu ssions.microsof t.comwrote in
news:98******** *************** ***********@mic rosoft.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**********@ro gers.com (Do not e-mail)
Jan 14 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
4396
by: Mike S. Nowostawsky | last post by:
I am getting this error when I try to run a program in my cgi-bin directory (don't know what I'm still missing to make it work): *** Authentication required! This server could not verify that you are authorized to access the URL "/~group3/cgi-bin/ack.cgi". You either supplied the wrong credentials (e.g., bad password), or your browser doesn't understand how to supply the credentials required.
3
13053
by: Zeke Hoskin | last post by:
Suddenly a stored procedure, very much like several others, is giving EXECUTE permission denied on object 'Add_Adjustment', database 'InStab', owner 'zhoskin'. server:Msg 229, Level 14, State 5, Procedure Add_Adjustment, Line 18. I'm zhoskin. I am the dbo and created the procedure, and when I look at its properties, I have EXEC permission. Line 18 is just the return statement. The values are all appropriate for the table. So what is...
5
4066
by: Chris Dugan | last post by:
Hi, has anybody come across a solution to running an Access97 database on Windows XP. The situation I have is an Access 97 database that runs perfectly from Win95/98 clients running Access97, the database sits on a Windows2000 server to which everyone has full NTFS access rights. The problem is the WinXP and Win2k clients which appear to run fine (also running Access97) in reading any existing data but as soon as you attempt to edit a...
1
2338
by: mangia | last post by:
I have several .NET websites running successfully on Windows 2003 Sever/IIS6 for over a year now. Today I decided to change my anonymous FTP site access using specific 'granted' or ‘denied’ IP addresses to 'non anonymous’ and require username password access. I created a user account and gave it the file permissions, tested and FTP site access works fine (again). Something done brought down the .NET websites! Now when...
3
1695
by: Steven Nagy | last post by:
Hi all, I have a problem where I am developing a site for a client that needs to perform a certain analysis against the database every hour, on the hour. The problem is that the hosting company will only allow a standard ASP.NET web app to be run on their server; no EXE's can be run. So I am not sure how I would implement functionality to run the required service. You see, its theoretically possible that no one would use the site on a
2
5454
by: axel22 | last post by:
Ok here it goes. 1. I've created a new web service project in F:\c#\WebSites\ServisBaze. 2. I've published the web service with IIS in a virtual directory who's actual path is: F:\c#\Published\ServisBaze 3. Tried opening it in a browser - it works perfectly. 4. Now I've added an SQL Database object Database.mdf into my project. 5. I've manually edited the database tables and added data. 6. I've added a webmethod 'izvadiImena' to work...
0
3556
by: =?Utf-8?B?RmlsaXBwbyBCZXR0aW5hZ2xpbw==?= | last post by:
I have developed a web service under ASP.NET2. this web service call another web service which need a SSL connection. Therefore I pass, to be able to connect, I pass credential and certificate X509Certificate x509cert = new X509Certificate(@"C:\Visual Studio Projects\DprGateway\Providers\Summit\Code\Src\Dpr.Gateway.Providers.Summit\Log\ais-services.p12", "password"); wsSummitProvider.ClientCertificates.Add(x509cert);
3
2151
by: Cor Pruim | last post by:
I have a very strange problem. I have written a Windows Service with VS2003 in vb.net. This service does some calculations and after that it needs to produce some Excel reports by getting data from an Oracle database. This has been working fine for two years and it still is working fine in our production environment. But after installing a new test server the problems started. I did many tests but there is something strange. When I start the...
11
2013
by: John Sheppard | last post by:
Hello there, I am running a webservice on IIS6, sometimes it runs at a reasonable speed, sometimes it runs painfully slow and sometimes inbetween. The application that consumes the service is vb.dotnet and runs on a local area network. Does anyone have any ideas? Where should I start to look? What could be causing this? Thank you for any help or ideas
0
10485
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10252
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10231
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10027
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9073
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6805
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5463
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
3759
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2938
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.