🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Update Resync not working

#4159
From: Tony
Date: Wed, 06 Mar 2002 00:49
19 lines
1792 bytes
PSS:

I solved the problem by using separate ADOConnection objects for client side
and server side cursors. Anyone have any more info or links to explain this
behavor?

"Tony" <hse@hill-soft.com> wrote in message news:3c80b3af_2@dnews...
> I convertied an Access 2000 db to MS-SQL server and now the ADO dynamic
> property "update resync" does not work. If I set adResyncAutoIncrement,
the
> auto inc ID fields contain 0 in the after post event. If I set
> adResyncInserts, the record disapears from the record set when posted and
> does not re-appear unless you close/open the recordset. This is true for
all
> tables in the database. I have another MS-SQL database on the same machine
> and same server that works fine. Thanks for any help.
>
>
>
Technical Details
Message-ID: <3c8566e7_1@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!priapus.visi.com!news-out.visi.com!hermes.visi.com!hub1.meganetnews.com!hub1.nntpserver.com!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!newsfeed.frii.com!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews
References: <3c80b3af_2@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,2a04f1052edacbc8
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-03-05 17:05:22 PST
From: "Tony" <hse@hill-soft.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3c80b3af_2@dnews>
Subject: Re: Update Resync not working
Date: Tue, 5 Mar 2002 19:49:16 -0500
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 165.121.212.183
Message-ID: <3c8566e7_1@dnews>
X-Trace: dnews 1015375591 165.121.212.183 (5 Mar 2002 16:46:31 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!priapus.visi.com!news-out.visi.com!hermes.visi.com!hub1.meganetnews.com!hub1.nntpserver.com!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!newsfeed.frii.com!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews