System.Data.OracleClient requires Oracle client software version 8.1.7 or g
lgarciaMar 20 2012 — edited Apr 10 2012I have a Desktop application that creates ASP.NET pages based on the settings in the application. This application can create connections on the fly through the Oracle Client and display the data. Now, when we deploy the resulting page to IIS, if the server has the Oracle client installed, it normally works as expected and retrieves the data. I have a new server installed where I set up the Oracle Client 11g, gave the user running the application pool in IIS (NetServices) full access to the Oracle_Home directory, I also checked the registry to make sure all was there and it seems to be. I did notice that we were missing the ODP.NET 4.0 (we are running .NET Framework 4) and I installed it... and still get the same error:
System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
at System.Data.OracleClient.OCI.DetermineClientVersion()
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
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 this point, I don't know what else to do... Any ideas, or suggestions would be appreciated.
Thanks!
Edited by: lgarcia on Mar 20, 2012 3:24 PM