Since most database vendors these days are providing high-performance 16
& 32-bit drivers with rich functionality with their offerings (we've
researched Oracle, Sybase, SQL Server, Informix, DB2, Interbase amongst
others...), we decided that we would develop a set of objects and
components which enable Delphi developers to access the full power of
ODBC without having to go through the BDE.
Basically, why use the BDE for generic database access when ODBC
provides the same thing. Sure, Borland has written the BDE into their
data-aware controls - but we have done a similar thing with ODBC.
During this ODBC development/testing, we've found some interesting
things: ODBC drivers (the more recent ones, that is) are only around
7-10% slower than their native counterparts, ie. should SQL Server
DB-LIB take 1sec to process a request, it's ODBC counterpart would take
However, we found that accessing a database using ODBC through another
driver interface (Borland's BDE and VB's JET come to mind...) proved
substantially slower. Results were a bit erratic, but often more than
2-12 times slower than native access to the database.
Other benefits of our route include:
Not having to depend on Borland for broad database support via
SQL Links (and pay the associated price!)
Not having to rely on Borland to release timeous SQL Links
updates when new versions of your database become available
Not having to guess whether errant database problems are caused
by the BDE, the SQL Links driver, the ODBC driver, or a
combination of these
Not having to learn two interfaces (ie. BDE calls & ODBC calls),
especially when most of your work is ODBC related
Not having to just guess how the BDE implements ODBC
driver-specific behaviour when things don't seem to work
Having full control over the power of ODBC
Although we have developed the software for our own use, we are
considering making a commercial version of our ODBC driver library
available. Currently, we support ODBC v2.5 with support for v3.0 due
within a couple of weeks.
Is anyone out there interested in such a thing???
Any feedback would be appreciated.
Manager, Client/Server Software Development
Compustat - 'Voted Top Development House in South Africa 1994'