BizTalk ODBC Adapter

A colleague of mine, Todd Van Nurden, has written an ODBC adapter for BizTalk Server 2004.  Download it from the GotDotNet workspace.  The ODBC adapter addresses some of the limitations of the SQL Adapter.  For example, it supports stored procedures that return multiple recordsets…

The Quick list:
Stored Procedures with out parameters (If the ODBC driver supports them)
Compound queries – More then one query performed in a single pass
Parameterization of raw SQL Statements (Enter your own SQL statements with parameters)
Batched queries – The request XML document can be nested with multiple parameter sets

It’s all good…