🚀 go-pugleaf

Hi Arnie,

Thanks for your answer. I have tried that suggestion already without any
luck. The CursorType is automatically set to ctDynamic on a TADOQuery. Im
using MDAC 2.6 Service pack 1. Maybe its a problem with the Microsoft OLE DB
Provider for SQL Server.

Best Regards,

Jakob Petersen
Microhouse

"Arnie Mauer" <arnie@vrms.com> skrev i en meddelelse
news:3b66cc59_1@dnews...
> Set the CursorType property to "ctKeyset".  This supports bookmarks
> which are required for a TDBGrid.
>
> Good luck,
> - Arnie
>
> "Jakob Petersen" <Jakob@microhouse.dk> wrote in message
> news:3b65ed06_1@dnews...
> > Hi,
> >
> > 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!!
> >
> > Best Regards,
> >
> > Jakob Petersen
> > Microhouse
> >
> >
>
>