🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: MS SQL with ADO or MS SQL with dbExpress?

#896
From: Ramesh Theivendran
Date: Wed, 11 Dec 2002 16:49
43 lines
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-mail
References: <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