dotConnect 7.8 with Oracle12c
Posted: 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:
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
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)
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