Article View: borland.public.cppbuilder.database.multi-tier
Article #673Re: Data Access w/ Legacy Database
From: Jerry Bloomfield (TeamB)
Date: Wed, 18 Apr 2001 03:18
Date: Wed, 18 Apr 2001 03:18
37 lines
2761 bytes
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!dnewsReferences:
<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