🚀 go-pugleaf

Jakob Petersen wrote:
> 
> I have established a ado connection in C++ Builder v5 SP1 ADO SP1 to a SQL
> Server 2000. I have set the CursorLocation in a TADOConnection to
> clUseServer and connected a TADOQuery to it. But when i connect a TDBGrid to
> the the query then i get an error saying that bookmarks are not support by
> the provider/connection. Cant SQL Server 2000 not use Server side cursors
> that are opened for bookmarks,updating,backward fetching and so on? I have
> no problems using Client side cursors but i really would like to use server
> cursors. No problems with server cursors on Oracle and Access!!

I tried this with SQL server 7 (sorry, I don't have 2000), and couldn't reproduce the
error. Sorry. You might try searching mers.com or groups.google.com for the exact
error message that you get. Maybe someone else has ran into this.

PS: if you don't use a client side cursor, then you won't get smooth scrolling in the
DBgrid. You will get that hoaky scrollbar where the scroll butt is at the top, in the
middle, or at the bottom, with no in betweens. For some people. Smooth scrolling is
important enough to use client side cursors. 

Harold Howe [TeamB]
http://www.bcbdev.com