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


      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.

    • #12132

      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.

    • #49763

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

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