Comet ODBC Client Gateway
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
· Microsoft FoxPro
· Microsoft Excel
· 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.
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.