Article View: borland.public.cppbuilder.database.ado
Article #5035Re: BDE vs ADO
From: Harold Howe (TeamB)
Date: Sun, 05 Aug 2001 21:28
Date: Sun, 05 Aug 2001 21:28
19 lines
1524 bytes
1524 bytes
Henrik Franz๏ฟฝn wrote: > > Why is ADO better than BDE?.. ADO is nice when the backend database is a microsoft product, such as MS SQL server. For SQL Server, I seem to get better performance than when using the BDE and SQL links. ADO is also easier to deploy. Some of the shortcomings of ADO include 1- conflicts between different versions 2- Doesn't offer a decent equivalent to CachedUpdates. There is an UpdateBatch mode which works well when updating a single dataset. But the UpdateBatch mode doesn't work very well wehn you update multiple tables from within the same transaction. It also does not offer an equivalent of the UpdateSQL component. Harold Howe [TeamB] http://www.bcbdev.com
Technical Details
Message-ID:
<3B6DBA79.676E156C@bcbdev.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!129.240.148.23!uio.no!newsfeed1.uni2.dk!newssuck.uni2.dk!dnewsReferences:
<3b6978b6_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,6c459a101940afe7 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-08-05 14:32:11 PST Message-ID: <3B6DBA79.676E156C@bcbdev.com> Date: Sun, 05 Aug 2001 16:28:25 -0500 From: "Harold Howe (TeamB)" <hhowe@bcbdev.com> X-Mailer: Mozilla 4.03 [en] (WinNT; I) MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: BDE vs ADO References: <3b6978b6_1@dnews> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit NNTP-Posting-Host: 24.22.227.236 X-Trace: dnews 997046894 24.22.227.236 (5 Aug 2001 14:28:14 -0700) Lines: 19 Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!129.240.148.23!uio.no!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews