Owen Allen signals that his collegue Todd Van Nurden has written an ODBC adapter for BizTalk Server 2004, and you can download it from the GotDotNet Workspace.
The ODBC adapter addresses some of the limitations of the SQL Adapter. Example of features:
- Stored Procedures with output parameters (if the ODBC driver supports them)
- Compound Queries - more than one query performed in a single pass
- Possibility to enter your own SQL statements with parameters
- Batched queries: the request XML document can be nested with multiple parameter sets
I think it's a tool that could be useful if you (like me) plan to work with BizTalk.