Hi all;
I am trying to connect using the connection string: "USER ID=hr;PASSWORD=hr;DATA SOURCE=mercury:1521/XE"
My connector class is: "Oracle.ManagedDataAccess.Client" which I believe is the connector that does not require the Oracle fat client to be installed.
And I am getting the error:
Oracle.ManagedDataAccess.Client.OracleException occurred
HResult=-2147467259
Message=TNS:listener does not currently know of service requested in connect descriptor
Source=Oracle Data Provider for .NET, Managed Driver
ErrorCode=-2147467259
DataSource=Oracle.ManagedDataAccess
Number=12514
Procedure=""
StackTrace:
at Oracle.ManagedDataAccess.Client.OracleException.HandleError(OracleTraceLevel level, OracleTraceTag tag, Exception ex)
at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession)
at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd)
at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd)
at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword)
at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, Byte[] securedPassword, Byte[] securedProxyPassword)
at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
at AutoTagCore.net.windward.autotag.datasource.ado.ConnectionDebugger.btnConnect_Click(Object sender, EventArgs e) in c:\src\jenova\Dev\Merge\AutoTag\AutoTagCore\net\windward\autotag\datasource\ado\ConnectionDebugger.cs:line 346
InnerException: OracleInternal.Network.NetworkException
HResult=12514
Message=TNS:listener does not currently know of service requested in connect descriptor
Source=Oracle.ManagedDataAccess
ErrorCode=12514
Number=12514
StackTrace:
at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
at OracleInternal.Network.OracleCommunication.Connect(String tnsDescriptor, Boolean externalAuth)
at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession)
InnerException:
Any idea why?
thanks - dave