Errors connecting to Oracle via Devart on new machine (urgent please help)
Posted: Mon 15 Feb 2016 16:27
Hello, I have an urgent issue. I have a new machine on which Devart dotConnect for Oracle and Oracle Client 11g is installed . Yet, when I ran my application, I got the following error:
"Can not obtain Oracle client information from registry. Make sure that Oracle Client Software is installed, or use Direct mode of connecting to server."
Source of error: Devart.Data.Oracle
Stack Trace: at Devart.Data.Oracle.OracleHomeCollection.a()
at Devart.Data.Oracle.OracleInternalConnection..ctor(b2 connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.aq.a(m A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, m 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()
Does anyone here have any insight into this? Here is my c# code that resulted in the error (note- I checked my tnsnames.ora file and it has the exact same entry as my local dev machine, which works):
connectionString = "data source=MyDevTNS;User ID=***;Password=******;persist security info=false;
using (OracleConnection connection = new OracleConnection(connectionString))
{
connection.Open();
}
"Can not obtain Oracle client information from registry. Make sure that Oracle Client Software is installed, or use Direct mode of connecting to server."
Source of error: Devart.Data.Oracle
Stack Trace: at Devart.Data.Oracle.OracleHomeCollection.a()
at Devart.Data.Oracle.OracleInternalConnection..ctor(b2 connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.aq.a(m A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, m 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()
Does anyone here have any insight into this? Here is my c# code that resulted in the error (note- I checked my tnsnames.ora file and it has the exact same entry as my local dev machine, which works):
connectionString = "data source=MyDevTNS;User ID=***;Password=******;persist security info=false;
using (OracleConnection connection = new OracleConnection(connectionString))
{
connection.Open();
}