Oracle ManagedDataAccess - Delayed Connection Request - Aggregation
Finally, I admit defeat and ask for help. I have done everything I can to fix this problem, but I seem to be unable to do so.
I am working with: VS2010 C # Oracle 12c ODP.Net Managed121012
I have inherited an application that uses both managed and unmanaged data DLLs. It worked until I installed the oracle. Then I re-installed the 11g client for a 64 bit machine. Immediately I noticed that there is only dataccess for data access for framework 2, but I continued anyway. Then I copied all the oci and ora files from the client_1 folder to the bin directory of my application and also the Oracle.DataAccess.dll file to my bin directory. I also copied the Oracle.ManagedDataAccess.dll file to this folder.
My application worked successfully as long as I didn't change anything in my datasets. I would love to continue like this, except that I needed to create more datasets. When I tried to add a new dataset, the Data Source Connection Wizard dropdown was blank. Then I tried to recreate the connections, but could only see .Net Framework DProviders. I couldn't see the managed provider. At some point I also got this error: "no data provider selected at this time".
After thinking about it, because the managed provider was not installed, I uninstalled the 11g client and installed the client with 64-bit 12c and copied all the relevant files to the trash of my application. I added the following lines to my app.config file:
<configSections>
<section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess" />
<system.data>
<DbProviderFactories>
<remove invariant="Oracle.DataAccess.Client" />
<remove invariant="Oracle.ManagedDataAccess.Client" />
<add name="ODP.NET, Managed Driver" invariant="Oracle.DataAccess.Client"
description="Oracle Data Provider for .NET, Managed Driver"
type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>
After that, I can now see some of the old data sources, but I cannot connect to my database because I receive a "Delayed Connection Request". When I manually create a new connection, I can connect to the unmanaged ISP fine, but I get a connection request error.
I am really at the end of my rope and will really appreciate fresh eyes before using the rope.
Thanks in advance.
source to share
I had an identical problem after switching to a managed driver. I even wrote a test application using both native and managed drivers. The conclusion was that the managed driver takes much longer to open a new connection than the native driver. The solution that worked for us was to set a large connection timeout using the connection string.
<connectionStrings>
<add name="ConnectionString" connectionString="data source=xxxx;user id=xxxx;password=xxxx;persist security info=false;Connection Timeout=120;" />
</connectionStrings>
source to share