asked on

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.

Before I begin, I already have tried this...

http://thedotnet.com/nntp/451661/showpost.aspx

I am trying to test an application hosted on iis, and connecting to a network available oracle database. When I add the service, it connects successfully, however when I run the application dependent on the data, I get this exception, and the web service and application cannot be displayed...

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection() at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command) at Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase.ExecuteReader(DbCommand command) at GlobalSubmit.DBAccess.DataAccess.FillLoadData(Int32 companyId) at GlobalSubmit.Validate.Submission.FillLoadData(Int32 companyId) at GSWebService.Service.FillLoadData(Int32 companyId) --- End of inner exception stack trace ---

daveamour

What version of asp.net is the IIS application running under?
I'm sure I had this problem and if I remember correctly it was running as ap.net 1.0 an dI switched it to 1.1.
I may be remembering incorrectly but if yours is running as 1.0 then worth a try as it only takes 2 seconds to test.

gsdevEE

ASKER

How would I perform this test - IIS is running in version 2.xxx

The set is

webservice install on vm
application install on vm (win 2003 server, both as virtuals in iis)
connecting to dedicated oracle server on another machine in the network, with the service set up, and connecting on the vm (I am able to query the oracle db using SQL plus ) - can you provide a little more info?

ASKER CERTIFIED SOLUTION

gsdevEE

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---&gt; System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.