Jaa

BizTalk ODBC Adapter

  • Artikkeli

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...

Comments

  • Anonymous
    February 15, 2005
    Owen,<br><br>can you point us at a list with all the available BTS adapters?<br>I mean intrinsic ones, third-party offerings, community contributions, samples like the one above... you get it :)<br><br>Thanks a lot!