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