ODBC Getting Started
From CometWiki
| Line 3: | Line 3: | ||
There are three basic steps required to set up the Comet ODBC Client Gateway. They are: | There are three basic steps required to set up the Comet ODBC Client Gateway. They are: | ||
| - | *1. Load the ODBC driver | + | *1. Load the ODBC driver |
| - | The Comet ODBC driver consists of the following two files | + | The Comet ODBC driver consists of the following two files |
| - | ODBCDRV.EXE | + | ODBCDRV.EXE |
| - | DBCD.DLL | + | DBCD.DLL |
Load these files to the Comet root directory (i.e., the directory from which the COSW.EXE program is launched). | Load these files to the Comet root directory (i.e., the directory from which the COSW.EXE program is launched). | ||
Revision as of 01:16, 29 May 2009
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).
