SQL adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL adapter

Viewing 2 reply threads
  • Author
    Posts
    • December 30, 2008 at 6:21 AM #21451
      community-content

        Hi,

        I am working on a project which involves sending messages to a SQL server database via SQL adapter. I only have access to invoke a stored procedure in the database on that server.

        I read a few articles which said that SQL adapter can only handle data sent in the SQL XML format. This sp which needs to be called isnt using FOR XML or anything like that.

        Is their a way I can still use the SQL adapter to send and receive records or do i need to wrap the request and response in a pipeline to make sure data reaches in SQL XML format.

        Any advice welcome.

        Thanks

      • January 5, 2009 at 12:07 AM #21473
        community-content

          The FOR XML clause is to generate the schema needed by BizTalk to call the procedure. All the schema has in it is, what to call, what type it is, what to send and what to expect back. After that, it literally makes a TSQL call to the DB.

          if you cant (or dont want to) write the schema up yourself, go to that stored proc and generate a script for it that will allow you to replicate it on a dev server. Add the FOR XML and XMLAUTO clauses and run your wizard against that. Finally, when you are ready to run it against production, change the connection string in the runtime properties on your admin tools and let er rip.

        • January 5, 2009 at 8:30 AM #21475
          community-content

            Hi,

            it could be much more easier to create a copy of sp, with a different name, with the required for xml tags.

            Laszlo

             

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