The following are the 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.
Workaround: Avoid using server-side cursors by setting UseCursor to 0.
You cannot use Prepared statements that are invoked when DynamicPrepare connection property is set to 1.
Workaround: Avoid using Prepared statements by setting DynamicPrepare to 0.
You cannot use output and input/output parameters on a stored procedure call.
Workaround: Upgrade to the current version of Adaptive Server.
Limited schema information available in the schema
rowsets obtained from IDBSchemaRowset::GetRowset.
Workaround: Upgrade to the current version of Adaptive Server.
