Oracle DB connectivity from ASP.NET fails
726245Oct 6 2009 — edited Oct 25 2010Our web application needs to work with different versions of Oracle DB. Everything seems to be fine with Oracle 11G. But we are facing a lot of issues when connecting to Oracle 10G (10.2.0.3, to be precise). I keep receving the following error
System.Exception: ORA-56609: Usage not supported with DRCP select table_or_view_name, logical_path, logical_name from r_report_tablelist ---> Oracle.DataAccess.Client.OracleException ORA-56609: Usage not supported with DRCP at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src) at Oracle.DataAccess.Client.OracleConnection.Open() at Novi.RelationalDataService.QueryExecutor.QueryExecutor.ExecuteQuery(String query) in C:\Brighton_V16\src\Novi.RelationalDataService\QueryExecutor\QueryExecutor.cs:line 59 --- End of inner exception stack trace ---
I don't understand what this DRCP change is? I do know that this is related to Connection pool settings. But I am not sure how to correct this issue. Can some one please suggest