Installation and Configuration of the Gateway ADC

Prerequisites

The DP4 ODBC Gateway ADC requires:

• An operational DP4 for Windows 3.x or Windows 9x/NT installation. If this is not available, refer to the appropriate DP4 installation guide for help on installing DP4 for your environment.
• The Microsoft ODBC driver manager.
• ODBC driver(s) for the foreign database(s).

Components

The ODBC Gateway ADC files are contained on the DP4 CD-ROM. You can install the required files from there by selecting the "ODBC Client Interface" product from within the DP4 Install program appropriate to your version of DP4.

How to Install, Configure and Use the ODBC Gateway ADC

Before you can use the Gateway ADC to access non-DP4 databases you must perform the following tasks, which are described in more detail in the linked topics:

1. Either Install the ODBC Client Interface product appropriate to your release of DP4, or copy the appropriate files in the list above from the DP4 CD-ROM, into an appropriate directory - that used for other DP4 programs is recommended.
   
   

2. Add the ODBC data source(s).

3. Run the DP4 installation aid program, AUXWINST, separately for each ODBC data source added in step 2. Each time the installation program runs it optionally produces two files:

   • A COPYDB-format file for building a DP4 database that structurally matches an ODBC data source;

   • An .INI file that contains initialisation information enabling a DP4 database built from the COPYDB-format file to work with the ODBC data source.

4. If necessary, run the DP4 utility MAKEDB and create the empty DP4 databases to be used with the ODBC data sources. With a text editor, review and, if necessary, amend any COPYDB-format files so that they will post without errors. Run the DP4 utility COPYDB and post the structure files to the empty DP4 databases. See Using the COPYDB-Format Files.

5. With a text editor, review and, if necessary, amend the .INI files created by AUXWINST, and merge them with the DP4 configuration file. See Gateway ADC Configuration Options.

6. Follow the instructions appropriate for your version of DP4 for loading the AUXWODBC ADC. See Loading the Gateway ADC.

The above instructions assume that you are going to be creating a DP4 database to match an existing non-DP4 database. It is possible that instead you want to create a non-DP4 database to match an existing DP4 database. There are two possibilities here:

• We supply a program (SQLMAKE) that generates a SQL data definition language file for the database. Provided the other database engine can understand DDL you can create a database using this file. It is possible that you will have to edit this file to get it to post to the other database, because of problems with reserved words and so on. The use of SQLMAKE is described in more detail here.

• The other database software may have a facility to import a database structure from another ODBC database. In this case you should be able to use that facility to create your database from the DP4 database. This process is described for Oracle in the installation notes for the Oracle Gateway ADC.