Article View: borland.public.cppbuilder.database.ado
Article #899Re: MS SQL with ADO or MS SQL with dbExpress?
From: Vassiliev V.V.
Date: Thu, 12 Dec 2002 09:23
Date: Thu, 12 Dec 2002 09:23
62 lines
3483 bytes
3483 bytes
This very depends on what you are doing and how ADO properties are set. Anyway, OLEDB Direct is faster :). ---------------------------------------------------------------- Regards, Viatcheslav V. Vassiliev http://www.oledbdirect.com The fastest way to access MS SQL Server, MS Jet (MS Access) and Interbase (LCPI provider, http://www.lcpi.lipetsk.ru) databases. "Ramesh Theivendran" <rtheivendran@borland.com> �������/�������� � �������� ���������: news:3df76be3@newsgroups.borland.com... > 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:
<3df86101@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mailReferences:
<3dde389e@newsgroups.borland.com> <3dde439b@newsgroups.borland.com> <3df76be3@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-12 02:17:20 PST From: "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> Newsgroups: borland.public.cppbuilder.database.ado,borland.public.cppbuilder.database.dbexpress References: <3dde389e@newsgroups.borland.com> <3dde439b@newsgroups.borland.com> <3df76be3@newsgroups.borland.com> Subject: Re: MS SQL with ADO or MS SQL with dbExpress? Date: Thu, 12 Dec 2002 12:23:36 +0300 Lines: 66 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: 212.188.101.125 Message-ID: <3df86101@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1039687937 212.188.101.125 (12 Dec 2002 02:12:17 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail