"The [Accelerator Solutions] from TwoConnect will help organizations that use BizTalk Server, Office SharePoint Server, SQL Server Integration Services, or any .NET custom application to reliably access critical line-of-business applications and key technologies. This allows development staff to spend less time in solving complex technical issues and more time on business solutions that bring competitive advantage to their companies."   

       - Steven Martin, Director-Connected Systems Division, Microsoft 

"The [Accelerator Solutions] from TwoConnect will help organizations that use BizTalk Server, Office SharePoint Server, SQL Server Integration Services, or any .NET custom application to reliably access critical line-of-business applications and key technologies. This allows development staff to spend less time in solving complex technical issues and more time on business solutions that bring competitive advantage to their companies."   

       - Steven Martin, Director-Connected Systems Division, Microsoft 

The Community BizTalk Adapter for ODBC is based on the code that was first made available on GotDotNet a few years ago. TwoConnect has refreshed this code, added an installer, and tested it against the latest BizTalk editions. We are releasing the updates back to the BizTalk developer, user and partner community as part of our ongoing community intitiatives. This is the second adapter package that TwoConnect makes available to the community after the very succesful release of the BizTalk WSE 3 adapter a couple of years ago. This adapter is useful in all ODBC based integration scenarios. The following are the new features added and fixes made to the old code base on GotDotNet.

New Features

    :: Poll While Data Found option on Receive Location

    :: Performance Counters and Event Source created at install time

    :: No longer requires Administrator rights at runtime

Fixes

    :: Can no longer be configured on a Request/Response Port

    :: Support for creating two way operations

Tested with

    :: BizTalk Server 2006 R2

    :: BizTalk Server 2009

    :: Microsoft SQL Server 2005/2008

    :: Sybase 15

    :: MySQL 5.1

Known issues

    :: Cannot change installation folder for BizTalk Server 2009/Windows Server 2008

    :: Auto generated port has incorrect type name

Please feel free to download the adapter and its code below and please provide your feedback to TwoConnect regarding this adapter by emailing CommunityODBC@twoconnect.com.

Thanks and enjoy playing with these bits.

The Community BizTalk Adapter for ODBC is based on the code that was first made available on GotDotNet a few years ago. TwoConnect has refreshed this code, added an installer, and tested it against the latest BizTalk editions. We are releasing the updates back to the BizTalk developer, user and partner community as part of our ongoing community intitiatives. This is the second adapter package that TwoConnect makes available to the community after the very succesful release of the BizTalk WSE 3 adapter a couple of years ago. This adapter is useful in all ODBC based integration scenarios. The following are the new features added and fixes made to the old code base on GotDotNet.

New Features

    :: Poll While Data Found option on Receive Location

    :: Performance Counters and Event Source created at install time

    :: No longer requires Administrator rights at runtime

Fixes

    :: Can no longer be configured on a Request/Response Port

    :: Support for creating two way operations

Tested with

    :: BizTalk Server 2006 R2

    :: BizTalk Server 2009

    :: Microsoft SQL Server 2005/2008

    :: Sybase 15

    :: MySQL 5.1

Known issues

    :: Cannot change installation folder for BizTalk Server 2009/Windows Server 2008

    :: Auto generated port has incorrect type name

Please feel free to download the adapter and its code below and please provide your feedback to TwoConnect regarding this adapter by emailing CommunityODBC@twoconnect.com.

Thanks and enjoy playing with these bits.

BizTalk ODBC Adapter Installer

BizTalk ODBC Adapter Source Code

BizTalk ODBC Adapter Installer

BizTalk ODBC Adapter Source Code

This software is provided "AS IS" and WITHOUT WARRANTY OR CONDITION OF ANY KIND, EXPRESSED OR IMPLIED, INCLUDING THOSE REGARDING THE ACCURACY OR COMPLETENESS OF THE SOFTWARE, INFORMATION, WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE, NON-INFRINGEMENT AND THOSE ARISING FROM A COURSE OF DEALING, USAGE OR TRADE PRACTICE. It is up to you to take precautions to ensure that whatever you USE for your use is free of such items as viruses, worms, trojan horses and other items of a destructive nature.

IN NO EVENT WILL ANY MEMBER OF TWOCONNECT BE LIABLE FOR ANY DAMAGES WHATSOEVER (INCLUDING, WITHOUT LIMITATION, THOSE RESULTING FROM LOST PROFITS, LOST DATA, LOST REVENUE OR BUSINESS INTERRUPTION) ARISING OUT OF THE USE, INABILITY TO USE, OR THE RESULTS OF USE OF, THIS SOFTWARE OR ANY SOFTWARE SOLD OR GIVEN AWAY BY TWOCONNECT WITHOUT LIMITING THE FOREGOING, NO MEMBER OF TWOCONNECT SHALL BE LIABLE FOR ANY SPECIAL, INDIRECT, INCIDENTAL, OR CONSEQUENTIAL DAMAGES THAT MAY RESULT FROM THE USE OF THIS SOFTWARE WHETHER ARISING UNDER CONTRACT, NEGLIGENCE, TORT OR ANY OTHER LAW OR CAUSE OF ACTION.

This software is provided "AS IS" and WITHOUT WARRANTY OR CONDITION OF ANY KIND, EXPRESSED OR IMPLIED, INCLUDING THOSE REGARDING THE ACCURACY OR COMPLETENESS OF THE SOFTWARE, INFORMATION, WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE, NON-INFRINGEMENT AND THOSE ARISING FROM A COURSE OF DEALING, USAGE OR TRADE PRACTICE. It is up to you to take precautions to ensure that whatever you USE for your use is free of such items as viruses, worms, trojan horses and other items of a destructive nature.

IN NO EVENT WILL ANY MEMBER OF TWOCONNECT BE LIABLE FOR ANY DAMAGES WHATSOEVER (INCLUDING, WITHOUT LIMITATION, THOSE RESULTING FROM LOST PROFITS, LOST DATA, LOST REVENUE OR BUSINESS INTERRUPTION) ARISING OUT OF THE USE, INABILITY TO USE, OR THE RESULTS OF USE OF, THIS SOFTWARE OR ANY SOFTWARE SOLD OR GIVEN AWAY BY TWOCONNECT WITHOUT LIMITING THE FOREGOING, NO MEMBER OF TWOCONNECT SHALL BE LIABLE FOR ANY SPECIAL, INDIRECT, INCIDENTAL, OR CONSEQUENTIAL DAMAGES THAT MAY RESULT FROM THE USE OF THIS SOFTWARE WHETHER ARISING UNDER CONTRACT, NEGLIGENCE, TORT OR ANY OTHER LAW OR CAUSE OF ACTION.