Sql Adapter Request-Response ports

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Sql Adapter Request-Response ports

Viewing 1 reply thread
  • Author
    Posts
    • December 14, 2006 at 11:25 PM #16940
      community-content

        hi,

         

        I am using a sql adapter in my orchestration.

        using a request response port to execute a stored proc in database.

        i have added a catch exception and i get a unspecified error sometimes .

        in biztalk logs i can see unspecified error.

         

        can anyone throw some light on unspecified error 

         

         

      • December 18, 2006 at 7:44 PM #16997
        community-content

          The errors returned from the SQL Adapter are not very good.

           

          I think they are returned as SOAP Fault.  You might want to try casting them (see my BizTalk 2004 Sample here http://www.biztalkgurus.com/Samples/Delivery-Notification-NAck-Orchestration.html).  

          Not really sure if this gives you a better error or not for SQL though.

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