From: jamesl@netcom.com (James Logajan) Subject: Re: ODBC competitors? Date: 1995/08/23 Message-ID: X-Original-Message-ID: #1/1 X-Deja-AN: 108643561 sender: jamesl@netcom7.netcom.com references: <0kCAeP200jcQ02zls0@andrew.cmu.edu> <5sL2hosrnTB@site71.ping.at> organization: Lugoj Incorporated newsgroups: comp.databases Walter Sommergruber (wsog@site71.ping.at) wrote: : James Logajan (jamesl@netcom.com) wrote on 21.08.95 : about "Re: ODBC competitors?": [elided] : > ODBC is a 'C' API to SQL-only RDBM's for applications running on MS-Windows. : Not SQL-only. It depends on your drivers. There are many available with : access to (e.g.) DBase-files or even ASCII-files. To form a query on those flat files you still need to use some query language. In the case of ODBC it is SQL. [elided] : > (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. : Why damage? Because the Microsoft specification is built with the DOS/Windows architecture in mind, which includes it's way of handling dynamic linked libraries (DLL's). All the setup and install DLL functions assume conventions applicable only to DOS/Windows. Dynamic linking is critical to what makes ODBC more than the usual run-of-the-mill standard. But dynamically linked libraries either do not exist for some OS's or exist in many disparate implementations (like on many variants of Unix).