Thread View: borland.public.cppbuilder.database.multi-tier
2 messages
2 total messages
Started by William Harazim
Tue, 17 Apr 2001 11:22
Data Access w/ Legacy Database
Author: William Harazim
Date: Tue, 17 Apr 2001 11:22
Date: Tue, 17 Apr 2001 11:22
17 lines
1813 bytes
1813 bytes
Greetings- I'm looking for a few suggestions/ideas regarding linking a C-ISAM database (running on HP-9000/UX 11.x) with Windows apps utilizing Borland data access components. Right now, I've managed to put together some specialized connection & dataset components; however, this, of course, is leading to some rather importable & scale-hostile client applications. Here's what i've managed to come up with as possible solutions: 1. Upgrade our database - currently not an option due to budget 2. Find a 3rd party driver - also not much of an option, s.a.a. 3. create an OCBC driver - a lot of work?? and $$ to Microsoft 4. create an IDAPI driver for use with the BDE 5. continue with my specialized components & hope sooner than later we will purchase a new database. 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. Suggestions are welcome. Will
Re: Data Access w/ Legacy Database
Author: 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>)
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads