- This topic has 2 replies, 1 voice, and was last updated 9 years, 3 months ago by
.
-
Posts
-
-
Dear all,
I am trying to build a simple biztalk application which get data from one SQL server 2005 and update them into another SQL server 2000/2005(multiple tables). Most websites suggested to use SQL Transport Schema Wizard to create schema. When I come to the step of entering a SQL statement or selecting a stored procedure, it prompts me an error and forbids me to preceed:
"Failed to execute SQL Statement. Please ensure that the supplied syntax is correct. New transaction cannot enlist in the specified transaction corrdinator."
I am creating a received port (using just select statement) but most websites stated that this error only occurs when creating send ports with update statement. I got stuck at this point and cannot find any solution. Pls help~!
P.S. If I am not on the right track, could anyone correct me? Many Thanks.
-
I have come across this "failed to execute sql error" Microsoft should do something to provide more info in the error message. In your case it looks like some problem with the DTC which is running on the biztalk machine, are u using a transaction shape in your orchestration? Depending on the serialization(transaction serialization not object serialization) mode this error can occur even when select is used.
-
http://geekswithblogs.net/sureshg/archive/2006/02/14/69456.aspx
http://support.microsoft.com/kb/899191/
Says this is because your invoker, Biztalk is not authenticating with the DTC participant(in this case the db server), it also contains a way to fix this as modifying the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC
Value name: AllowOnlySecureRpcCalls
Value type: REG_DWORD
Value data: 1value data to 0, although setting this value to 0 could have security implications that are beyond the scope of this blog :DD..just kidding.
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.