473,890 Members | 1,330 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Oracle 9i & Windows Service Program Error

MAL
Hello,

I have 2 classes that work great as a windows app to retrieve and
process data from an Oracle9i db. When I implement them in a Service
program running as Local System, it fails on the .open. I am using
OLEDB for Oracle 9.2.0.4. I have verified the Oracle Client install,
Local Sys' path variable, and followed MSKB article 259959(Debuggin g
connectivity issues w/ Oracle).

Here is the error:
Error #1
Message: Oracle error occurred, but error message could not be
retrieved from Oracle.
NativeError: 0
Source: Microsoft OLE DB Provider for Oracle
SQLState:

Connection string:
conn.Connection String = "Provider=MSDAO RA;Persist Security
Info=false;Pass word=TIGER;User ID=SCOTT;Data Source=DATA1;

Can anyone point me to an example of Oracle DB access in a windows
service program?

Any help is appreciated. Thanks in advance.
Nov 20 '05 #1
1 3031

"MAL" <ir************ *@hotmail.com> wrote in message
news:a2******** *************** ***@posting.goo gle.com...
Hello,

I have 2 classes that work great as a windows app to retrieve and
process data from an Oracle9i db. When I implement them in a Service
program running as Local System, it fails on the .open. I am using
OLEDB for Oracle 9.2.0.4. I have verified the Oracle Client install,
Local Sys' path variable, and followed MSKB article 259959(Debuggin g
connectivity issues w/ Oracle).

Here is the error:
Error #1
Message: Oracle error occurred, but error message could not be
retrieved from Oracle.
NativeError: 0
Source: Microsoft OLE DB Provider for Oracle
SQLState:

Connection string:
conn.Connection String = "Provider=MSDAO RA;Persist Security
Info=false;Pass word=TIGER;User ID=SCOTT;Data Source=DATA1;

Can anyone point me to an example of Oracle DB access in a windows
service program?


There are several things left out of that article. If the program works in
a desktop app, but not in a service then the problem is one of two things:
Secutiry or Environment.

Security:

A service runs in a different security context. Change the service login to
be your interactive login to test if it is a security issue. If it is, give
the service account rights to the [Oracle Home] directory.
Environment:

Every processes inherits its environment from its parent process. The
parent process for a service is the Service Control Manager. The
environment for the Service Control Manager is a snapshot of the environment
at bootup, and cannot be changed without rebooting.

Several environment variables affect the Oracle Client. Most important is
the PATH. If the [Oracle Home]\bin folder is not in the path, then you
cannot load OCI.DLL.

This one is simple to fix. Make sure the environment is correct in Control
Panel>System> Advanced and then reboot.

David
Nov 20 '05 #2

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

Similar topics

0
1812
by: Phoenix_Dfire | last post by:
We've had a working application for the last year, which involved Microsoft ASP serving up web pages, which were generated from data retrieved from an Oracle Database via ADO. However, as part of this fix for the msblast virus, our server was upgraded to service pack 4 and as a result, our web pages started to fall over with an ASP ‘0x800a01fb' error when attempting to read the EOF flag of a recordset. At present we use Oracle's...
1
7082
by: Wayne Happ | last post by:
I'm a new Oracle user. I've installed Oracle 9i on a Linux RedHat machine V9.0 and it's running. I took a Windows XP machine and installed the Oracle client on it along with PL/SQL developer from All-Around-Software. I try to connect and I get an error message ORA-12545 "Connect failed because target host or object does not exist".
3
5260
by: Jake McDermott | last post by:
We have a few developers that use Oracle 9i (9.2.0.4.0) on their personal workstations for testing purposes. Recently, weve made the decision to upgrade them to WinXP so that they are able to use some other functionalities of the OS, but we are running into a totally odd problem with Oracle. It seems that, Installing Oracle runs just fine, and our ant scripts to build the database work well...but when we reboot the computer, the database...
1
5698
by: Artur Kowalski | last post by:
I have a NotifyIcon in my Windows Service project and I am trying to add a ContextMenu to this NotifyIcon or use some of the mouse events. Everything isn't working. I think so base class of the service System.ServiceProcess.ServiceBase don't catchWindows messages like mouse or timer messages. Any Idea? Thanks,
6
4348
by: Jeff | last post by:
Has anyone had any luck accessing an Oracle database from a web service? I have a C# DLL with various code to query an Oracle database. If I call the methods in this DLL from a Windows Forms application everything works just fine. However, if I call the methods in this DLL from a web service, I receive the following error when the database connection is opened: Error: ORA-12154: TNS:could not resolve service name Does anyone know...
0
5789
by: ʹÃûÑï | last post by:
ORA-03114: not connected to ORACLE && MS's Bug?? DataBase:Oracle 817 using OracleClient,net framework 1.1 I'm using ADO.Net in C# with Oracle 817. and following is my public data access class. using System.Data.OracleClient;
13
7488
by: Chris Botha | last post by:
The machine is running XP Pro with all the latest service packs, etc. I must access an Oracle database so I installed the Oracle client stuff. I can query Oracle from a Windows app, no problem. Using the exact same code (copy and paste) into a Web app I get the following error "Error while trying to retrieve text for error ORA-01019". Security I thought, so I use Impersonation on the Web site, then the aspnet_wp.exe crashes with "The...
5
7141
by: Rob R. Ainscough | last post by:
I'm using the Diagnostics.Process approach to shelling out run the following: C:\Windows\System32\MSIEXEC.EXE /x {73F1BDB7-11E1-11D5-9DC6-00C04F2FC33B} /q ..FileName = "C:\Windows\System32\MSIEXEC.EXE" ..Arguments = "/x {73F1BDB7-11E1-11D5-9DC6-00C04F2FC33B} /q" ..Start() I do a WaitForExit and get an error code back from MSIEXEC of 1605 -- this
1
2775
by: megaman1 | last post by:
I’m trying to connect with perl DBD::Oracle on Windows to Oracle DB (Linux). I compiled the Oracle.dll using the commands “perl Makefile.pl” “nmake” and “nmake install”, but when I try to connect to the DB, I get the following runtime error: “R6034 an application has made an attempt to load the C Runtime library incorrectly. Please contact the applications’ support team for more information.” I suspect that I mixed the versions of VC...
0
11232
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
10819
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
10923
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
9633
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...
1
8016
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7169
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
6045
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4676
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4271
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.