Article View: borland.public.cppbuilder.database.ado
Article #896Re: MS SQL with ADO or MS SQL with dbExpress?
From: Ramesh Theivendran
Date: Wed, 11 Dec 2002 16:49
Date: Wed, 11 Dec 2002 16:49
43 lines
2945 bytes
2945 bytes
dbExpress access to MSSQL is mutiple times faster than ADO. T.Ramesh. "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message news:3dde439b@newsgroups.borland.com... > >We are wondering if we should go with ADO or > > dbExpress? > > ADO is based on OLEDB. OLEDB (and ADO) internally is much more powerfull > than dbExpress. dbExpress has only one plus over OLEDB (and ADO) - it is > cross-platform. If you need speed working with MS SQL Server you can use > OLEDB Direct (http://www.oledbdirect.com) that works with OLEDB and avoids > ADO layer. Even without OLEDB Direct I recommend you ADO over dbExpress for > MS SQL Server. > > >Can dbExpress even be used with MS SQL? > > Yes, Delphi 7 even has MS SQL dbExpress driver. BCB 7 very probable will > have too. With BCB 6 you should use third-party drivers such as OLEDB > Express (can be found on http://www.oledbdirect.com, goto OLEDB Express). > > ---------------------------------------------------------------- > Regards, > Viatcheslav V. Vassiliev > http://www.oledbdirect.com > The fastest way to access MS SQL Server and MS Jet (MS Access) databases. > > "bmkiss67" <bmkiss67@aaahawk.com> �������/�������� � �������� ���������: > news:3dde389e@newsgroups.borland.com... > > We have a cople of app that we have written a while ago that use the BDE. > > We have upgraded to BCB6, which I hope wasn't a mistake, and are looking > to > > get away from the BDE now. We are wondering if we should go with ADO or > > dbExpress? Can dbExpress even be used with MS SQL? > > > > > > Thanks > > > > > >
Technical Details
Message-ID:
<3df76be3@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3dde389e@newsgroups.borland.com> <3dde439b@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: fb4e2,d4f3ca338c81514c X-Google-Attributes: gidfb4e2,public X-Google-Thread: 10698b,d4f3ca338c81514c X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-12-11 08:56:08 PST Reply-To: "Ramesh Theivendran" <rtheivendran@borland.com> From: "Ramesh Theivendran" <rtheivendran@borland.com> Newsgroups: borland.public.cppbuilder.database.ado,borland.public.cppbuilder.database.dbexpress References: <3dde389e@newsgroups.borland.com> <3dde439b@newsgroups.borland.com> Subject: Re: MS SQL with ADO or MS SQL with dbExpress? Date: Wed, 11 Dec 2002 08:49:47 -0800 Lines: 45 Organization: Borland Software Corporation X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 143.186.37.44 Message-ID: <3df76be3@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1039625187 143.186.37.44 (11 Dec 2002 08:46:27 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!c03.atl99!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail