| Settt 2005-10-28, 10:22 am |
| 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 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.
I'd appreciate any help.
Thanks in advance. |