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…

One thought on “BizTalk ODBC Adapter”

  1. Owen,
    <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>Thanks a lot!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s