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
    • #12134

      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

      • #12135

        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

    • #12133


      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.



    • #49753

        First Frost by Sarah Addison Allen · 9781250190970

      • #49755

          Empire of Lies by Raymond Khoury : 9781250210968

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