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 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.