From: Ke Jin Subject: Re: ODBC competitors? Date: 1995/08/22 Message-ID: <41cqj2$ma1@knot.queensu.ca> X-Original-Message-ID: <41cqj2$ma1@knot.queensu.ca>#1/1 X-Deja-AN: 108643443 references: <0kCAeP200jcQ02zls0@andrew.cmu.edu> organization: Empress Software Inc. newsgroups: comp.databases In article James Logajan writes: >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. Then you mean ANSI embedded SQL is a competitor of ANSI dynamic SQL. In fact, ANSI-ISO SQL standard includes embedded SQL specs, dynamic SQL specs(92) and CLI(call level interface) specs(96 draft), etc. And ODBC standard includes both ODBC (dynamic) SQL and ODBC CLI. To access a (relational) database (i.e. SQL engine), you need to execute a (dynamic) SQL query through CLI (either ANSI or ODBC) and retrive query results. None of the above specs ( embedded sql, dynamic sql and cli) is included as a competitor of others. Ke