Error in Oracle Adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Error in Oracle Adapter

Viewing 2 reply threads
  • Author
    Posts
    • July 20, 2010 at 4:45 AM #25288
      community-content

        Hi! I’m using WCF-Oracle Adapter, I’m trying to configure to make a polling every X seconds but when I start the application it gives me the next error:

         

        The adapter “Oracledb” raised an error message. Details “Microsoft.ServiceModel.Channels.Common.ConnectionException: Due to an Oracle Client limitation, the adapter failed to open a connection. This is because either (a) ambient transaction is present and the TNS alias is longer than 39 characters, or (b) ambient transaction is present and a non-TNS based URI was used. To resolve this, use a TNS alias to connect to Oracle and make sure it is not more than 39 characters.

         

        How can i know the TNS name???

         

        Thanks

      • July 20, 2010 at 7:50 AM #25290
        community-content

          Hi,

           

             Did you check the receive location (where you are using the Oracle Adapter) for its connection binding? That’s where you would find the TNS alias…

           

             Daniel.

           

          • July 20, 2010 at 8:26 AM #25293
            community-content

              I’ have configured the conecction binding with servicename and servername. Have I to configure the connection bing with the TNS alias? How can I know the TNS alias in that case?

              • July 20, 2010 at 8:40 AM #25294
                community-content

                  Hi,

                   

                     The TNS alias is the same as the ODBC data source name set up on that server. Check the following blog on more information on how to troubleshoot LOB Oracle adapters (look for the entry titled “Using LOB Oracle adapters with BizTalk Server 2006 R2” and dated September 11):

                  http://bibhakar.spaces.live.com/blog/

                   

                     Daniel.

                   

            • November 17, 2020 at 6:31 PM #50353
              biztalkgurus

                Medicine for the Earth: How to Transform Personal and Environmental Toxins by Sandra Ingerman — 9780609805176

            • Author
              Posts
            Viewing 2 reply threads
            • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.