ODBC Getting Started
From CometWiki
| (4 intermediate revisions not shown) | |||
| 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 | + | |
| - | ODBCDRV.EXE <br/> | + | The Comet ODBC driver consists of the following two files |
| - | DBCD.DLL | + | |
| + | ODBCDRV.EXE<br/> | ||
| + | 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). | ||
| Line 15: | Line 18: | ||
GATEWAY = 5,0; | GATEWAY = 5,0; | ||
| - | 3. Configure the ODBC data source you will be using | + | *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. | 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, | + | For example, several of Signature’s sample Internet Basic/ODBC programs interact with one of the sample Access databases that Microsoft ships with Office2000.<br/> |
| + | The sample database is called "Northwind Traders." <br/> | ||
| + | To configure that data source, | ||
| - | a. go to the Control Panel | + | a. go to the Control Panel |
| - | b. select ODBC Data Sources (32-bit) | + | b. select ODBC Data Sources (32-bit) |
| - | c. at the User DSN tab, choose the Add option | + | c. at the User DSN tab, choose the Add option |
| - | d. select the Microsoft Access Driver and click on the Finish button | + | d. select the Microsoft Access Driver and click on the Finish button |
| - | e. in the Data Source Name field, type: Northwind | + | 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: | + | 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 | c:\Program Files\Microsoft Office 2000\Office\Samples\northwind.mdb | ||
| - | Note: Follow a similar procedure to configure other data sources. | + | '''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). | At this point, your Comet system is ready to communicate with the configured ODBC data source(s). | ||
Latest revision as of 01:19, 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).
