Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

This SQL adapter which is also a part of the BizTalk Adapter Pack 2.0 can be used to connect BizTalk applications to SQL Server. The adapter replaces the current native SQL adapter and offers many more features.

• Insert/Update/Delete/Select operations on tables and views


• Invoke (SQL and CLR) Stored procedures, scalar valued functions , table value functions


• Supports execution of generic T-SQL statements, via the ExecuteReader(), ExecuteNonQuery() and ExecuteScalar() operations


• Configurable polling – polling statement, polling interval, receive multiple result sets


• Support for x86 and x64 platforms


• Support for new data types in SQL2005 and SQL2008 (notably FILESTREAM, varbinary (max))


• Support for UDTs


• Ability to pass table value parameters


• Composite operations - invoke operations on multiple tables and call any number of stored procedures in the same transaction


• SQL query notifications


• Ability to directly call stored procedures which used the ‘for xml’ style supported by the BizTalk 2006 SQL adapter to ease backward compatibility

SQL Server versions supported SQL 2000, SQL 2005, SQL 2008In order to use this adapter and be eligible for support you must have a valid BizTalk Server license.

Files

Status: Deleted This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to July 2015.

No files found

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• Windows XP SP3



• Windows Server 2003 SP2




• Windows Server 2003 R2



• Windows Server 2008



• Windows Vista


• .NET 3.5 SP1

Please install the WCF LOB Adapter SDK SP2 before installing this adapter