🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #673

Re: Data Access w/ Legacy Database

#673
From: Jerry Bloomfield (TeamB)
Date: Wed, 18 Apr 2001 03:18
37 lines
2761 bytes
On 17 Apr 2001 04:22:51 -0700, "William Harazim" <wharazim@fulcoinc.com>
wrote:

>Here's what i've managed to come up with as possible solutions:
>1. Upgrade our database - currently not an option due to budget

Have you considered looking into Interbase?  Borland has released Interbase
v6 as Open Source,  so that database server will not cost a large sum of
money (other than your conversion process)...

>2. Find a 3rd party driver - also not much of an option, s.a.a.

I do not know for sure,  but you might have some luck looking into the
tools offered by Sequiter Software (makers of CodeBase).

>3. create an OCBC driver - a lot of work?? and $$ to Microsoft
>4. create an IDAPI driver for use with the BDE
...
>I'm not sure what's involved with options 3 & 4, but they seem to be the best direction to head as far as RAD & future scalability. 

Option 4 might not be the silver bullet you are thinking it will be.  IIRC,
the SDK for BDE drivers is quite out-dated,  and is no longer supported as
TClientDataSet can be used to implement essentially the same functionality,
and is included with the Client/Server (or now Enterprise) edition of the
compilers.

The ODBC driver might be your best route.  Keep in mind that you do not
need to implement the full ODBC API in your custom driver.  You only need
to implement the sections of the API which you use.  You can always go back
later and add additional functionality to your driver as needed,  but you
can start out very simple and grow from there...

Jerry Bloomfield (TeamB)
-- 
http://www.teamb.com                                      JersWork@wwa.com
Please do *NOT* send private e-mail without prior permission (my anti-spam 
filters will probably just delete it anyway <g>)
Technical Details
Message-ID: <vf1qdtgek121bqe99palddtf9ragukg80v@4ax.com>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!193.174.75.178!news-fra1.dfn.de!news-koe1.dfn.de!RRZ.Uni-Koeln.DE!nntp.CS.Uni-Magdeburg.De!PeerFeed.KWeb.on.ca!dnews
References: <3adc278b$1_2@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,87a2ac8ad4c8728a
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-04-17 20:17:31 PST
From: "Jerry Bloomfield (TeamB)" <JersWork@wwa.com>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Re: Data Access w/ Legacy Database
Date: Tue, 17 Apr 2001 22:18:16 -0500
Organization: LSVFA - Latest Software Version Freaks Anonomous
Message-ID: <vf1qdtgek121bqe99palddtf9ragukg80v@4ax.com>
References: <3adc278b$1_2@dnews>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 157.238.73.57
X-Trace: dnews 987563764 157.238.73.57 (17 Apr 2001 20:16:04 -0700)
Lines: 37
X-Authenticated-User: jerswork
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!193.174.75.178!news-fra1.dfn.de!news-koe1.dfn.de!RRZ.Uni-Koeln.DE!nntp.CS.Uni-Magdeburg.De!PeerFeed.KWeb.on.ca!dnews