The following are limitations of ASE ADO.NET Provider when used with Adaptive Server version 12.x:
You cannot use Server-side cursors that are invoked when UseCursor property is set to “true”. The workaround is to not use the server-side cursors; to do so, set UseCursor to “false”.
You cannot use Prepared statements that are invoked when prepare method on the AseCommand class is called. The workaround is to not use Prepared statements; to do so, do not call prepare method on the AseCommand class.
You cannot use output and input/output parameters on a stored procedure call.
GetSchemaTable returns incomplete result set column data.
You cannot use AseCommandBuilder class.
Workaround: Upgrade to the current version of Adaptive Server.
