Can’t use the procedure with SQL adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Can’t use the procedure with SQL adapter

  • This topic has 2 replies, 1 voice, and was last updated 3 years ago by biztalkgurus.
Viewing 2 reply threads
  • Author
    Posts
    • October 28, 2005 at 12:57 PM #12131
      community-content

        Hello,

        I have a simple procedure on a remote database. I’m adding a generated item, SQL Adapter, setting the connection string, selecting the send port type, selecting a stored procedure. I’m selecting the needed procedure, generating it and when I’m pressing next, I get the following error:
        \”Failed to execute SQL Statement. Please ensure that the supplied syntax is correct. The transaction has already been implicitly or explicitly committed or aborted\”

        I’d appreciate any help.
        Thanks in advance.

      • October 28, 2005 at 3:22 PM #12132
        community-content

          One more thing:

          I tested the procedure with SQL Query Analyzer and it worked very well.

          Another thing is that I’m working with 2 BizTalk servers. On one server this project works fine, on another it gives me this error.
          But I can’t find any differences between the settings of this 2 servers.

        • November 11, 2020 at 4:44 PM #49763
          biztalkgurus

            The Dirty Girls Social Club — Alisa Valdés-Rodríguez — 9781250765864

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