Connecting to an Oracle DB through an XML web service

Hi,
I am trying to connect to an Oracle database in a remote machine through an XML web service. The driver used isSystem.Data.OracleClient which comes with .net framework 1.1. When I try to connect, it throws an exception saying"System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater". But I have Oracle 9i Client 9.2 installed in my machine. Another thing is this only occurs in my office PC where automatic updates are enabled. At my home PC which it's disabled and has Oracle server installed, everything run smoothly. Also the problem doesn't occur when I try to connect to the database through the client directly(without the XML service). Please help.

Thanks.

[785 byte] By [aragon] at [2007-12-16]

«« Memory usage of application increasing automatically !
»» April CTP:error when attaching db and when creating file in filegroup

# 1

If I remember correctly, Oracle's client installer only grants access to the directory where the client is installed (look for oci.dll) to administrators. You'll need to manually grant the account running the XML Web Service read access to the directory where oci.dll is installed.

I hope this information proves helpful.

David Sceppa
ADO.NET Program Manager
Microsoft

DavidSceppa at 2007-9-9 >