dotConnect 7.8 with Oracle12c

dotConnect 7.8 with Oracle12c

Postby 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
lingster
 
Posts: 2
Joined: Tue 22 Mar 2016 17:08

Re: dotConnect 7.8 with Oracle12c

Postby 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/revision_history.html
Pinturiccio
Devart Team
 
Posts: 2021
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle