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.

Posted on 2009-02-14
Last Modified: 2013-12-18
Before I begin, I already have tried this...

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 ---
Question by:gsdevEE
    LVL 19

    Expert Comment

    What version of is the IIS application running under?
    I'm sure I had this problem and if I remember correctly it was running as 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.

    Author Comment

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

    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?

    Accepted Solution

    Set through provider correction

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API ( has made its way into the popular lexicon of the English language.  A few years ago, …
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now