Using the ODBC Adapter with Sybase ASE

BizTalk 2010 does not have an adapter for Sybase. The only adapter that I could find was the free Community BizTalk Adapter for ODBC from twoConnect.

The adapter does have limitations.

• When using Insert, Update, or Delete Table Operations, there is no return value. It only supports a one-way operation.
• You cannot use Output parameters in Stored Procedures. 

Recommendation: Use a stored procedure with an return value.

Technorati Tags: ODBC,Adapter,Sybase,client,requirements,data,Oracle,Database,BizTalk