dotConnect 7.8 with Oracle12c

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
lingster
Posts: 2
Joined: Tue 22 Mar 2016 17:08

dotConnect 7.8 with Oracle12c

Post by lingster » Tue 22 Mar 2016 17:45

Hi,

We are presently using dotConnect 7.8 with Oracle 11g server.
We are in the process of upgrading our Oracle servers to 12c and we are experiencing the following errors:

Code: Select all

System.Data.EntityException: The underlying provider failed on Open. ---> Devart.Data.Oracle.OracleException: Server did not respond within the specified timeout interval
   at Devart.Data.Oracle.ap.a(b7 A_0, o A_1)
   at Devart.Data.Oracle.OracleInternalConnection..ctor(b7 connectionOptions, OracleInternalConnection proxyConnection)
   at Devart.Data.Oracle.ao.a(p A_0, Object A_1, DbConnectionBase A_2)
   at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, p A_1, DbConnectionBase A_2)
   at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
   at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
   at Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0)
   at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
   at Devart.Common.DbConnectionBase.Open()
   at Devart.Data.Oracle.OracleConnection.Open()
   at HibernatingRhinos.Profiler.Appender.ProfiledDataAccess.ProfiledConnection.Open()
   at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
   --- End of inner exception stack trace ---
   at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
   at System.Data.EntityClient.EntityConnection.Open()
   at System.Data.Objects.ObjectContext.EnsureConnection()
   at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
   at System.Data.Objects.ELinq.ObjectQueryProvider.<>c__DisplayClass0`1.<GetElementFunction>b__7(IEnumerable`1 sequence)
   at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
   at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
   at System.Linq.Queryable.Count[TSource](IQueryable`1 source)
Can you confirm if 7.8 is compatible with 12c, if so are there any changes we would need to make to the connection string or indeed any server side settings?

our connection string is:
Data Source=ora_db;User ID=user;Password=pwd;

I have also tried adding: "Connection Timeout=30;" but this does not help.

Thanks,
Ling

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: dotConnect 7.8 with Oracle12c

Post by Pinturiccio » Wed 23 Mar 2016 10:16

Oracle 12c is supported since dotConnect for Oracle 8.0.17. For more information, please refer to http://www.devart.com/dotconnect/oracle ... story.html

Post Reply