Re: Strange TNS problem

From: Jim Kennedy <>
Date: Tue, 09 Dec 2003 15:36:21 GMT
Message-ID: <VZlBb.346556$275.1142660_at_attbi_s53>

You open and close a connection on every call? Hopefully, you are using some sort of connection pooling or you are creating a massive performance problem. Try connecting with sqlplus. Looks like your tnsnames.ora file does not have the right stuff in it.
"Demetris" <> wrote in message
> Hello there.
> I have ORACLE server on AIX 5.1.
> I have another server (BIZTALK) with Oracle client 8.1.7.
> The system is running ok. I can connect from the client on my database
> server just fine.
> However at certain stages we get the error below when it tries to open
> a connection.Please note that we are loading 150,000 records currently
> and we open / close a connection for every call.
> ORA-12154: TNS:could not resolve service name
> - at System.Data.OracleClient.OracleException.Check(OciHandle
> errorHandle, Int32 rc)
> at
System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(Str ing
> userName, String password, String serverName, Boolean
> integratedSecurity, Boolean unicode)
> at System.Data.OracleClient.OracleInternalConnection.Open(Object
> transact)
> at
System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionStrin g
> parsedConnectionString, Object transact)
> at System.Data.OracleClient.OracleConnection.Open()
> at BiztalkAIC.BiztalkAIC.LaikiToBYNXRequest_AIC(XmlDocument doc)
> at BiztalkAIC.BiztalkAIC.ProcessMessage(String strDocument)
> [0x0159] The server encountered a transport error while processing
> the messaging port "Mainframe To Bynx", which uses a transport
> component with a ProgID of "BiztalkAIC.BiztalkAIC".
> [0x012b] A transmission attempt failed.
> Do you have any idea how to troubleshoot this?
> Thank you
Received on Tue Dec 09 2003 - 16:36:21 CET

Original text of this message