MS Oracle Client - OCI throws "Specified module could not be found

[Guest]

Hi,

We are trying to connect oracle 9i database through windows services
application using ADO.NET [MS Oracle Client]. When the service tries to
connect oracle 9i database, OCI.DLL throws an exception as "The specified
module could not be found".

The same code is working good when we run as a windows application or web
application. The issue is only when we call the same code from windows
services.

Environment Details:
Windows 2003 stand-alone server
Oracle 9i [ 9.2.0.1.0 ] Database Server/Client
MS .NET v1.1

Any immediate help would be greatly appreciated.

Thanks.
Prabakaran.G

 

[Miha Markic [MVP C#]]

Hi,

Probably, the account service is running under, has not enough privileges
(NTFS read) to Oracle folders.

 

[Guest]

Dear Miha,

I have checked and assigned all rights to the user. Also I have tried with
the service as running under local "Administrator". still the problem exists.

Hi,

Probably, the account service is running under, has not enough privileges
(NTFS read) to Oracle folders.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Hi,

We are trying to connect oracle 9i database through windows services
application using ADO.NET [MS Oracle Client]. When the service tries to
connect oracle 9i database, OCI.DLL throws an exception as "The specified
module could not be found".

The same code is working good when we run as a windows application or web
application. The issue is only when we call the same code from windows
services.

Environment Details:
Windows 2003 stand-alone server
Oracle 9i [ 9.2.0.1.0 ] Database Server/Client
MS .NET v1.1

Any immediate help would be greatly appreciated.

Thanks.
Prabakaran.G

 

[Roy Fine]

Hi,

Probably, the account service is running under, has not enough privileges
(NTFS read) to Oracle folders.

NTFS read by itself is not enough privileges - you will need read/write.
Try read for all of bin and read for all of %OracleHome%\Network\Admin. And
then Read/Write for wherever the log files are.

regards
roy fine

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Hi,

We are trying to connect oracle 9i database through windows services
application using ADO.NET [MS Oracle Client]. When the service tries to
connect oracle 9i database, OCI.DLL throws an exception as "The specified
module could not be found".

The same code is working good when we run as a windows application or web
application. The issue is only when we call the same code from windows
services.

Environment Details:
Windows 2003 stand-alone server
Oracle 9i [ 9.2.0.1.0 ] Database Server/Client
MS .NET v1.1

Any immediate help would be greatly appreciated.

Thanks.
Prabakaran.G

 

[Guest]

Hi Roy,

I have tried as you said, still the problem exist. Ans I have already
told that everything is working good when i call the method to connect oracle
9i from web-application or windows application. The issue is only for windows
service application. And the windows service is running under administrator
privilege.

Hi,

Probably, the account service is running under, has not enough privileges
(NTFS read) to Oracle folders.

NTFS read by itself is not enough privileges - you will need read/write.
Try read for all of bin and read for all of %OracleHome%\Network\Admin. And
then Read/Write for wherever the log files are.

regards
roy fine

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Hi,

We are trying to connect oracle 9i database through windows services
application using ADO.NET [MS Oracle Client]. When the service tries to
connect oracle 9i database, OCI.DLL throws an exception as "The specified
module could not be found".

The same code is working good when we run as a windows application or web
application. The issue is only when we call the same code from windows
services.

Environment Details:
Windows 2003 stand-alone server
Oracle 9i [ 9.2.0.1.0 ] Database Server/Client
MS .NET v1.1

Any immediate help would be greatly appreciated.

Thanks.
Prabakaran.G