Error while accessing stored procedure on biztalk server 2004 from client development environment.

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Error while accessing stored procedure on biztalk server 2004 from client development environment.

Viewing 2 reply threads
  • Author
    Posts
    • September 26, 2006 at 9:35 PM #15857
      community-content

        I receive the error message while using stored procedure on Biztalk server2004 from client dev. environmrnt.

         Failed to execute SQL statement.Please ensure that supplied syntax is correct.The transaction has already has been implicitly or explicitly commited or aborted.

        I have added SQL adapter(Add->Add generated items->Add Adapter) and using Stored proc. in Database on server.This error comes for each an every stored proc though its syntax is coorect.

        PLEASE tell me what to do?

      • September 30, 2006 at 11:24 PM #15914
        community-content

          Could it be a permission problem? 

          Does your BizTalk host user have rights to run the procedure?

        • February 16, 2007 at 4:03 AM #17697
          community-content

            please restart the machine…

            • February 27, 2007 at 12:32 AM #17802
              community-content

                Can you paste the Stored procedure here.

                Is it getting executed properly if u manually execute it.

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