Re: SQL Server/ADO CursorLocation property

Article View: borland.public.cppbuilder.database.ado

Article #5164

Back to borland.public.cppbuilder.database.ado Previous Next

#5164

From: Arnie Mauer
Date: Tue, 31 Jul 2001 15:18

27 lines
1801 bytes

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
>
>

Technical Details

Message-ID: <3b66cc59_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.he.net!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References: <3b65ed06_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,ddc205b2df1b5a30
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-07-31 08:20:55 PST
From: "Arnie Mauer" <arnie@vrms.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3b65ed06_1@dnews>
Subject: Re: SQL Server/ADO CursorLocation property
Date: Tue, 31 Jul 2001 11:18:44 -0400
Lines: 29
Organization: VRMS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 209.140.211.97
Message-ID: <3b66cc59_1@dnews>
X-Trace: dnews 996592729 209.140.211.97 (31 Jul 2001 08:18:49 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.he.net!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message