The following are limitations of Adaptive Server ADO.NET Data 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 true. Workaround: set UseCursor to false.
You cannot use Prepared statements that are invoked when prepare method on the AseCommand class is called. Workaround: 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.