Saturday, December 17, 2011

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: ,,,,,,,,

No comments:

Post a Comment