The server is 32bit and Oracle client is 32bit.
Oracle 10g
I eventually tried setting up my application on VS2008 that was already installed on the server and I ran the application from the IDE (IDE used development server) and everything worked well but the version packaged and installed on IIS for production would not work on the same server.
I am getting the error below.
Please help resolved the issue. Being battling with it for days now. Thanks.
Code: Select all
Devart.Data.Linq.LinqCommandExecutionException: Error on opening DbConnection. ---> System.IO.FileNotFoundException: Can not load Oracle client library oci.dll from home OraDb10g_home1.
at Devart.Data.Oracle.OracleHome.get_ClientVersion()
at Devart.Data.Oracle.av.a(Boolean A_0, Boolean A_1, OracleHome A_2, Boolean A_3)
at Devart.Data.Oracle.OracleInternalConnection..ctor(aa connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.cs.a(k A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, k A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionPoolGroup.a(DbConnectionPool A_0, DbConnectionBase A_1)
at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Oracle.OracleConnection.Open()
at Devart.Data.Linq.Provider.k.a.g()
--- End of inner exception stack trace ---
at Devart.Data.Linq.LinqCommandExecutionException.CanThrowLinqCommandExecutionException(String message, Exception e)
at Devart.Data.Linq.Provider.k.a.g()
at Devart.Data.Linq.Provider.k.a.b(IConnectionUser A_0)
at Devart.Data.Linq.Provider.k.b(IConnectionUser A_0)
at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)
at Devart.Data.Linq.Provider.DataProvider.ExecuteAllQueries(CompiledQuery compiledQuery, Object[] userArguments)
at Devart.Data.Linq.Provider.DataProvider.Devart.Data.Linq.Provider.IProvider.Execute(Expression query)
at Devart.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.Count[TSource](IQueryable`1 source)
at com.encentral.trustfund.dal.NsitfScheduleDal.getStates()
at com.encentral.trustfund.bll.NsitfScheduleBll.getStates()
at com.encentral.trustfund.service.NSITFWebService.getStates()