The SQL Transport Schema Generation Wizard closes unexpectedly in BizTalk Server 2006 or in BizTalk Server 2004 (917847)

The information in this article applies to:

Microsoft BizTalk Server 2006 Standard Edition
Microsoft BizTalk Server 2006 Enterprise Edition
Microsoft BizTalk Server 2006 Developer Edition

SYMPTOMS

In Microsoft BizTalk Server 2006 or in Microsoft BizTalk Server 2004, the SQL Transport Schema Generation Wizard closes unexpectedly when you try to generate a schema for a SQL adapter send port. This problem occurs if you try to generate a schema for one of the following updategrams to update a database table in Microsoft SQL Server 2005:

An Insert updategram
An Update updategram
A Delete updategram

Additionally, you may receive an error message that resembles the following:

Failed to execute SQL Statement. Please ensure that the supplied syntax is correct. New transaction cannot enlist in the specified transaction coordinator.

You may receive this error message when you use the SQL Transport Schema Generation Wizard to query a database table in SQL Server 2005.

CAUSE

This problem occurs when the database table contains a column that has one of the following data types:

The varbinary(MAX) data type
The varchar(MAX) data type
The nvarchar(MAX) data type
The xml data type

These data types are not supported by the SQL adapter in BizTalk Server.

RESOLUTION

These data types are new data types in SQL Server 2005. When the database table contains a column that has one of these data types, do not use the SQL adapter in BizTalk Server to insert data into the database table. Additionally, do not use the SQL adapter in BizTalk Server to retrieve data from the database table.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about data types in SQL Server 2005, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms187752(SQL.90).aspx

For more information about support for BizTalk Server 2004 databases in SQL Server 2005, click the following article number to view the article in the Microsoft Knowledge Base:

915919 Microsoft SQL Server 2005 is not currently supported for Microsoft BizTalk Server 2004 databases

Modification Type:	Major	Last Reviewed:	5/9/2006
Keywords:	kbBTSAdapters kbBTS kbtshoot kbprb KB917847 kbAudDeveloper