🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: BDE vs. ADO

#4622
From: Arnie Mauer
Date: Thu, 08 Nov 2001 17:41
49 lines
2908 bytes
We switched a few months ago.  The BDE simply wasn't robust enough.
Basically, it's a 16 bit application that didn't actually grow - it
stretched.  It was designed for file-based (DBase, Paradox) databases, not
client server.

We're using it with Oracle 8.1.7.  I found it flakey with 8.1.6 and earlier.

You should make sure there is an OLEDB provider available for your target
DB's.  If not, you'll have to use ODBC.

Converting from the BDE to ADOExpress can be a bit painful.  Our product
contains 175 EXEs/DLLs/BPLs and almost all had BDE components.  It took 6
developers 3 weeks to do the mechanical conversion.  I'm still tracking down
ADO related bugs that were not persent with the BDE.

Good luck,
- Arnie

"Jeremy R. Wright" <jwright@zevex.com> wrote in message
news:3be816c8$1_2@dnews...
> I thought I had seen some posts on this earlier but I couldn't find any.
We
> are about to start work on a huge redesign and upgrade on one of our
> software projects, and there has been much discussion as to what database
we
> should use for our data. We're considering giving the user a choice
between
> Oracle, MS Access, and Paradox, but in order to do so, we need to use a
> database engine that is reliable, robust, and efficient. We have used BDE
in
> the past simply because it came bundled with C++ builder, but we've had a
> few small compatibility issues and heard of others having larger problems
> (large BLOB fields getting corrupted, conflicts with WordPerfect, etc.).
>
> A colleague of mine mentioned using ADO. After a few searches on the web,
I
> still haven't come up with much that actually describes the pros and cons
of
> using ADO, especially in contrast with BDE. I figured C++ Builder and
Delphi
> users would know the most about this because many of you have used both.
If
> someone can point me in the right direction or provide me with some good
> facts (or opinions), it would be greatly appreciated.
>
> Jeremy Wright
> JTech Medical
>
>
Technical Details
Message-ID: <3beac3cd$1_1@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!europa.netcrusader.net!usenetserver.com!128.230.129.106!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews
References: <3be816c8$1_2@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,4aa5b65f163c98c2
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-11-08 09:47:20 PST
From: "Arnie Mauer" <amauer@vrms.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3be816c8$1_2@dnews>
Subject: Re: BDE vs. ADO
Date: Thu, 8 Nov 2001 12:41:33 -0500
Lines: 51
Organization: VRMS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 209.140.211.97
Message-ID: <3beac3cd$1_1@dnews>
X-Trace: dnews 1005241293 209.140.211.97 (8 Nov 2001 09:41:33 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!europa.netcrusader.net!usenetserver.com!128.230.129.106!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews