From: kennedy-downwithspammersfamily@attbi.net   
      
   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.   
   Jim   
   "Demetris"  wrote in message   
   news:c5285638.0312090400.2016582c@posting.google.com...   
   > Hello there.   
   > I have ORACLE 8.1.7.4 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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)