Cursor Type Changed

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 16
Joined: Tue 11 Oct 2005 21:04

Cursor Type Changed

Post by jigesh » Tue 18 Apr 2006 16:44

Jigesh wrote: I am using Delphi 7, SDAC, SQL7 and SQL2000.

I have set the cursor type for my tables to ctDynamic. If I connect to SQL7 with my application everything works fine, but if I connect to SQL2000 with my application I get an error message "EDAError in module xxxx.exe. Cursor type changed for statement." immediately after login.

Please help me.

Thanks in advance.

Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Wed 19 Apr 2006 12:17

For some reasons your SQL statement can not be treated as dynamic cursor and cursor converted to a default result set.
Please see MSDN for more information about server cursors.

Post Reply