Article View: borland.public.cppbuilder.database.ado
Article #4622Re: BDE vs. ADO
From: Arnie Mauer
Date: Thu, 08 Nov 2001 17:41
Date: Thu, 08 Nov 2001 17:41
49 lines
2908 bytes
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!dnewsReferences:
<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