Home   Products

Comet ODBC Client Gateway


 

Overview

 

The Comet ODBC Client Gateway provides the power for Comet applications to access databases that are compatible with the Open Database Connectivity (ODBC) standard. For example, Internet Basic programs can read and write data in the following types of databases:

 

        Microsoft Access

        SQL Server

        DBASE

        Microsoft FoxPro

        Microsoft Excel

        Paradox

        Oracle

        other ODBC data sources

 

The ODBC Client Gateway offers excellent expansion opportunities for existing applications as well as eComet applications.

 

The ODBC Client Gateway is an add-on to Comet2000/Comet2002.

 

Background information

 

Open Database Connectivity (ODBC) is a very popular interface for accessing a database. By using ODBC statements in an application program, you can access data in a large number of different databases. The main proponent and supplier of ODBC programming support is Microsoft.

 

ODBC is implemented as an application programming interface (API). To interact with an ODBC-compatible database, your program only need to include ODBC function calls and statements in Structured Query Language (SQL). The ODBC Manager determines how to contend with the type of database you are targeting.

 

ODBC accomplishes this by inserting a middle layer, called a database driver, between an application and the DBMS. The purpose of this layer is to translate the application's data queries into commands that the DBMS understands. For this to work, both the application and the DBMS must be ODBC-compliant -- that is, the application must be capable of issuing ODBC commands and the DBMS must be capable of responding to them.

 

The Comet ODBC Client Gateway includes such a driver. This driver program is activated when an Internet Basic program opens an ODBC gateway (a type 5 gateway in the system configuration). From that point on, the CONTROL statement sends commands to the ODBC driver. READ and WRITE statements are used to retrieve and send data to the ODBC database itself. Signature Systems provides documentation and sample Internet Basic programs that demonstrate how to use the ODBC driver with a sample Access database.