sql adapter updategrams

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › sql adapter updategrams

  • This topic has 4 replies, 1 voice, and was last updated 3 years ago by biztalkgurus.
Viewing 3 reply threads
  • Author
    Posts
    • November 1, 2005 at 1:57 AM #12134
      community-content

        I think your Send Port is messed up. Did you use the SQL Adapter to generate your outbound schema?

        I’m not an SQL Adapter Guru but see if Todd’s white paper helps: http://msdn.microsoft.com/library/en-us/BTS_2004WP/html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp?frame=true&_r=1

        • October 28, 2005 at 3:50 PM #12135
          community-content

            hai friends,
            I want to send datas from xml file to sql database with sql adapter and updategrams.
            I configured receive port to use file adapter and send port to use sql adapter.
            In the receive folder,when I put the file xml ,it vanishes but it does not insert in the sql table.

            It gives the following error

            The adapter failed to transmit message going to send port \”SQL://KAVITHA/bizTest/\”. It will be retransmitted after the retry interval specified for this Send Port. Details:\”HRESULT=\”0x80040e14\” Description=\”Impossible to find stored procedure’s name\”

            The adapter \”SQL\” raised an error message. Details \”HRESULT=\”0x80040e14\” Description=\”Impossible to find stored procedure’s name.\”

            My question is Does updategrams use stored procedures?
            Why it is asking for stored procedures?

            Can anyone help me?
            Thank you

        • November 3, 2005 at 7:39 AM #12133
          community-content

            Hi,

            I had the same problem a while ago. I think it’s the error message that is confusing, as the updategram does not use stored procedures. Double check that you have the correct shcema, and that you are mapping to it, and sendng the correct message.

            Regards,

            Alan

          • November 11, 2020 at 12:51 PM #49753
            biztalkgurus

              First Frost by Sarah Addison Allen · 9781250190970

            • November 11, 2020 at 1:30 PM #49755
              biztalkgurus

                Empire of Lies by Raymond Khoury : 9781250210968

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