Biztalk Server 2004 ODBC Adapter Community Supported Sample

  • Article

I found a few more interesting things in my email.  He's the first one:Apparently lots of people want a generic database adapter for BizTalk Server. On our product planning list it was "one below the cut-off line" for BizTalk Server 2006 - ie. it didn't quite make it but it was close. 

Where was I.  So you want an ODBC adapter? Ok.  Todd Van Nurden - super star MS technology specialist -has been using his "spare" time constructively to create a pretty fully fledged ODBC Adapter for BizTalk Server 2004.  Its a sample (ie. not supported offering) but it comes with complete source code and its pretty fully featured (including add generate items!).  It uses ADO.NET and he has done smoke-screen testing against a bunch of databases including: Oracle, DB2, SQL, MySQL, SQLLite etc. Give it a whirl and let us know if you have any issues as I'd consider it a "beta" (but a solid one) at this point.

Grab it here and thank Todd for his efforts.