The following are the 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.
Workaround: Avoid using server-side cursors by setting UseCursor to false.
You cannot use Prepared statements that are invoked when the prepare method on the AseCommand class is called.
Workaround: Avoid using Prepared statements by not calling the prepare method on the AseCommand class.
You cannot use output and input/output parameters on a stored procedure call.
Workaround: Upgrade to the current version of Adaptive Server.
GetSchemaTable returns incomplete result set column data.
Workaround: Upgrade to the current version of Adaptive Server.
You cannot use AseCommandBuilder class.
Workaround: Upgrade to the current version of Adaptive Server.