OLE DB adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › OLE DB adapter

Viewing 1 reply thread
  • Author
    Posts
    • May 17, 2010 at 11:54 AM #24712
      community-content

        Hi,

        I’m having an error "An Exception occurred attempting to submit a Batch of Messages to the Database Transport." when trying to send a request. I have no problems with receive.  I’m connecting to AS400 via OLEDB adapter. I have no clue what is wrong.

        Thanks,

         

      • May 17, 2010 at 12:46 PM #24713
        community-content

          Hi,

           

            Check the following MSDN thread on connecting to AS400 from BizTalk:

          http://social.msdn.microsoft.com/Forums/en-US/biztalkr2adapters/thread/54f2de69-f63c-4730-b884-03353a20ae31

           

             Daniel.

           

          • May 17, 2010 at 1:40 PM #24714
            community-content

              Thanks Daniel,

              I have connection and simple select  is working fine. I’m trying to send a request with parameters to select values depending on that parameters. Where I specify the select statement? Adapter generated following schema:

              -Request

                  -Operation

                         -table

                              @sql

                               -parameters

                                         –  p1

                                          – p2

               

               

              Thanks,

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