Database Guide


Creating an ODBC.INI file and setting up database drivers

VisualAge ODBC Support uses a file called ODBC.INI to store ODBC configuration and connection information. This file contains a data sources section, which provides the ODBC driver manager with a list of data sources supported for your connection requests. Each data source listed in the data sources section has a corresponding data source name (DSN) section, which defines information such as the ODBC driver location, the name of your database server, the name of the database, logon information, and any specific database information.

The ODBC Administrator uses a file called ODBCINST.INI as the source of information about installed drivers. VisualAge ODBC Samples includes an application that you can use to create the ODBCINST.INI file. Under OS/2 or Windows, once you have installed the ODBC druverse, use the ODBC Administrator. under OS/2 or Windows to create your ODBC.INI file. The ODBC Administrator is provided with VisualAge ODBC Support. (Under UNIX, you cannot use the ODBC Administrator.)

In general, to create your ODBC.INI file for a particular database, you need to refer to the help for that database.

To create the ODBC.INI file, follow these steps:

  1. Make sure you have loaded the VisualAge: Database, ODBC Samples feature into your image.
  2. Evaluate the following expression:
    AbtOdbcLauncherView new openWidget
    
  3. Select ODBC Administrator to create the ODBC.INI file.

UNIX
The ODBC administrator is not available on UNIX, and you have to edit the .odbc.ini manually.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]