Error while creating SQL Adapter

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

Error while creating SQL Adapter

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Ask XML questions here] >> BizTalkers >> Error while creating SQL Adapter

Page: [1]

Message

<< Older Topic Newer Topic >>

Error while creating SQL Adapter - 26 June 2007

adnanjamil

Posts: 2
Score: 0
Joined: 15 June 2007
Status: offline

Hi,

I am getting below error when creating SQL Adapter metadata from Visual Studio 2005. Error Is "Failed to execute SQL Statement. Please ensure that the supplied syntax is correct. New transaction cannot enlist in the specified transaction coordinator" I am not using Varchar(MAX), nVarChar(Max), Binary(MAX) or XML data type in my query but keep getting this error message.

I am new to Biztalk world. Could anybody let me guide how to fix this error or is any other way to create SQL Adapter.

Your help much appriciated

Regards

Post #: 1

RE: Error while creating SQL Adapter - 28 June 2007

adnanjamil

Posts: 2
Score: 0
Joined: 15 June 2007
Status: offline

Nobody knows the answer of my question. I am keep getting this error even on simple query (Select * from customers). Please help

(in reply to adnanjamil)

Post #: 2

RE: Error while creating SQL Adapter - 12 December 2007

RyanElee

Posts: 16
Score: 0
Joined: 20 August 2007
Status: offline

Specify those columns' name an try again, don't use the '*'.

(in reply to adnanjamil)

Post #: 3

RE: Error while creating SQL Adapter - 15 January 2008

Posts: 4
Score: 0
Joined: 15 January 2008
From: Egypt
Status: offline

Adnan-
This error is related to MSDTC ( Microsoft Data Tranasaction Coordinator), check the following steps to solve this issue :

1) you should manipulate the communication settings on both of the BizTalk machine and the SQL machine using the instructions this article :
http://msdn2.microsoft.com/en-us/library/ms679479.aspx

2) In addition, you should add MSDTC program and his port into the exception list in the Windows Firewall settings. using the following steps:
1. In Control Panel, open Windows Firewall.
2. Click the Exceptions tab, and then click Add Program.
3. Click Browse, and then add c:\windows\system32\msdtc.exe.
4. In Programs and Services, select the Msdtc.exe check box, and then click OK.
5. Click the Exceptions tab, and then click Add Port.
6. Add 135 as a port number and choose TCP

for more information , please check the following articles:
• http://msdn2.microsoft.com/en-us/library/ms686976.aspx
• http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306843

P.S : DON'T Forget to restart both of the machines , "the Server and the Client"

< Message edited by U3 -- 15 January 2008 >

_____________________________

Best regards,
Mohammad Yousri

http://mohammad-yousri.blogspot.com/

(in reply to adnanjamil)

Post #: 4