SQL Server/ADO CursorLocation property

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

Article #5163

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

#5163

From: Jakob Petersen
Date: Mon, 30 Jul 2001 23:23

15 lines
1541 bytes

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: <3b65ed06_1@dnews>

Path:

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,ddc205b2df1b5a30,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-07-30 16:28:16 PST
From: "Jakob Petersen" <Jakob@microhouse.dk>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: SQL Server/ADO CursorLocation property
Date: Tue, 31 Jul 2001 01:23:58 +0200
Lines: 17
Organization: Microhouse Aps
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
NNTP-Posting-Host: 130.228.39.74
Message-ID: <3b65ed06_1@dnews>
X-Trace: dnews 996535558 130.228.39.74 (30 Jul 2001 16:25:58 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!cyclone.bc.net!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews