ODBC Getting Started

From CometWiki

Getting Started

There are three basic steps required to set up the Comet ODBC Client Gateway. They are:

• 1. Load the ODBC driver

The Comet ODBC driver consists of the following two files

ODBCDRV.EXE
DBCD.DLL

Load these files to the Comet root directory (i.e., the directory from which the COSW.EXE program is launched).

• 2. Configure the ODBC gateway

Add the following line to the [GATEWAYS] section of your Comet INI file:

GATEWAY = 5,0;

• 3. Configure the ODBC data source you will be using

This is done in the ODBC Data Sources (32-bit) section in the Control Panel for your system.

For example, several of Signature’s sample Internet Basic/ODBC programs interact with one of the sample Access databases that Microsoft ships with Office2000.
The sample database is called "Northwind Traders."
To configure that data source,

a.	go to the Control Panel
b.	select ODBC Data Sources (32-bit)
c.	at the User DSN tab, choose the Add option
d.	select the Microsoft Access Driver and click on the Finish button
e.	in the Data Source Name field, type: Northwind
f.	select the Northwind Traders database location. On a typical single-user MS Office installation, the Northwind Traders database is located at: 

c:\Program Files\Microsoft Office 2000\Office\Samples\northwind.mdb

Note: Follow a similar procedure to configure other data sources.

At this point, your Comet system is ready to communicate with the configured ODBC data source(s).