home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!dtix!darwin.sura.net!mips!swrinde!dptspd!iquery!matt
- From: matt@iqsc.COM (Matt Reedy)
- Newsgroups: comp.databases
- Subject: Re: SQL Access Group Application Interface
- Keywords: SQL, API, UNIX, 4GL, SAG
- Message-ID: <1992Aug22.170101.10629@iqsc.COM>
- Date: 22 Aug 92 17:01:01 GMT
- References: <18AUG199209582102@stars.gsfc.nasa.gov>
- Distribution: usa
- Organization: IQ Software Corp.
- Lines: 27
-
- In article <18AUG199209582102@stars.gsfc.nasa.gov> thompson@stars.gsfc.nasa.gov (William Thompson) writes:
- >Does anyone know anything about the SQL Access Group (SAG), and about their
- >standardized Application Interface (API)? (I think I got the acronyms
- >correct.) I'm not a database programmer myself, but I've been recently looking
- >into the question of buying a database product. In our application there would
- >also be other database applications belonging to other groups, which would be
- >from a variety of vendors, but all SQL. I've heard that each manufacturer uses
- >a different standard for passing SQL queries and answers across the network,
- >and that the SAG-API is supposed to address this issue, and try to standardize
- >it. Does anybody have any more details?
- >
-
- The SAG has endorsed a standard API (also called a CLI - Call Level Interface),
- and there have been demonstrations by several of the RDBMS vendors showing
- the same application program accessing the different databases using the
- same API. However, those were demos only, and as of today, the RDBMS vendors
- still use different APIs (we work with Oracle, Informix, Ingres and Sybase
- and they are all significantly different).
-
- Microsoft has endorsed this standard and is producing a product called ODBC
- (Open DataBase Connectivity) which is a Windows DLL that will allow an
- application program to call the SAG standard set of SQL API calls and get
- access to a variety of data sources. Microsoft is busy getting database
- and data access vendors to write ODBC drivers which will provide this
- capability.
-
- matt
-