The following are limitations of Adaptive Server OLE DB Provider when used with Adaptive Server version 12.0.x:
You cannot use Server-side cursors that are invoked when UseCursor property is set to 1. The workaround is set UseCursor to 0.
You cannot use Prepared statements that are invoked when DynamicPrepare connection property is set to 1. The workaround is to set DynamicPrepare to 0.
You cannot use output and input/output parameters on a stored procedure call.
Schema information available in the schema row sets obtained from IDBSchemaRowset::GetRowset is limited.
Workaround: Upgrade to the current version of Adaptive Server.