We have been connecting directly to an Oracle database for years, but now they want us to connect to an OID (Oracle Internet Directory), which is basically means I'm providing an alias and there's a lookup to point to the oracle server. The way I'm connecting right now is by pointing Telerik.DataAccess to a connection in my config file that looks like this:
<connection id="abc">
<databasename>dbName</databasename>
<servername>asdfasdf.abc.com,3203</servername>
<integratedSecurity>False</integratedSecurity>
<user>FSAPPP01</user>
<password>AbCdXyZ</password>
<backendconfigurationname>oracleConfiguration</backendconfigurationname>
</connection>
Switching the servername to the OID is causing the error below. Does anyone know if this is possible with DataAccess?
"ORA-12547: TNS:lost contact Telerik.OpenAccess.RT.sql.SQLException: ORA-12547: TNS:lost contact ---> Oracle.DataAccess.Client.OracleException: ORA-12547: TNS:lost contact\r\n at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable, OracleLogicalTransaction m_OracleLogicalTransaction)\r\n at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src, OracleLogicalTransaction m_oracleLogicalTransaction)\r\n at Oracle.DataAccess.Client.OracleConnection.Open()\r\n at OpenAccessRuntime.Intellitrace.OpenConnection(DbConnection connection, String connectionString, String id)\r\n at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes)\r\n --- End of inner exception stack trace --
-\r\n at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes)\r\n at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, DBDriver& driver, Connection& conn, ConnectionPoolType poolType)"