Article View: borland.public.cppbuilder.database.ado
Article #4159Re: Update Resync not working
From: Tony
Date: Wed, 06 Mar 2002 00:49
Date: Wed, 06 Mar 2002 00:49
19 lines
1792 bytes
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!dnewsReferences:
<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