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

    Like

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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