pg.ddx.ioUniversity INGRES on Usenet (1985-1995): threads about Berkeley INGRES, QUEL and EQUEL from comp.databases.ingres, comp.databases and net.database
From: jamesl@netcom.com
Subject: Re: ODBC competitors?
Date: 1995/08/21
Message-ID: <jameslDDoIwE.LJ3@netcom.com> (raw)
References: <0kCAeP200jcQ02zls0@andrew.cmu.edu>
Andrew A. Houghton (ah0i+@andrew.cmu.edu) wrote:
: Are there any generic ODBC-like competitors out there? I'm just
: learning about ODBC, and it seems that the world has jumped on the
: ODBC bandwagon.. doesn't anyone have anything bad to say about it? Ad
: if so, what?
There are now a few attempts at ODBC-based API's for other platforms; I
haven't really looked them over to make any informed comments on them.
The closest "competitor" would be the ANSI standard for embedded SQL.
But if you're looking for someone to say something bad about ODBC, I'd be
happy to fill this void by analysing the following statement:
ODBC is a 'C' API to SQL-only RDBM's for applications running on MS-Windows.
(1) ODBC is very language specific. It is not a protocol, ala X-Windows, but
just a late attempt to regulate the 'C' API. All other languages (Smalltalk,
Cobol, Fortran, Lisp, APL, Basic, etc. ad nauseum), past, present, and
future, need not apply.
(2) ODBC is very SQL specific. QUEL and all other query languages, past,
present, and future, need not apply. And forget object-oriented databases.
(3) ODBC is loosely tied to MS-Windows. Considerable damage must be done to
the ability to handle multiple simultaneous data source connections in order
to port it to other platforms, such as Unix.
(4) While the world is jumping on the ODBC bandwagon, there have been rumors
that Microsoft would jump off in favor of something based on OLE.
This is all that I can think of off the cuff. If you want more bad stuff
on ODBC, just ask and I can expand and refine this list.