Previous Topic

Next Topic

Configure a Data Source (UNIX and VMS)

A data source configuration is a collection of information that identifies the database you want to access using the ODBC driver. You must configure a data source before connecting to a database through ODBC.

To configure a new data source on UNIX and VMS

  1. Run the Ingres ODBC Data Source Administrator utility, iiodbcadmin.

    The ODBC Administrator Main Menu form is displayed. This form lists all currently configured data sources.

    ODBC Administrator Main Menu

  2. Select the Create menu option.

    The following form is displayed:

  3. Supply a name, and then select Save.

    A pop-up menu is displayed with a list of available installed drivers:

    Select Driver Screen

  4. Select a driver and data source name.

    The Data Source Configuration Page is displayed:

  5. Fill in the necessary information as required. For more information, see Data Source Configuration Form.
  6. Select the Advanced menu option.

    The Advanced Configuration Options form is displayed:

    For information on this form, see Advanced Data Source Configuration Options.

  7. Review the displayed information. To change an advanced option value, place the cursor on the desired option and select Edit. This action toggles the current value to the alternate value (only two values exist for each option). Select End when finished.

    The Data Source Configuration form is displayed.

  8. Select Save.

    The new configuration is saved, and is included in the list of data sources on the Ingres ODBC Administrator Main Menu form.

Previous Topic

Next Topic

Data Source Configuration Form (UNIX and VMS)

The Data Source Configuration form of the Ingres ODBC Administrator has the following options:

Previous Topic

Next Topic

Advanced Data Source Configuration Options (UNIX and VMS)

The Advanced Data Source Configuration Options form of the Ingres ODBC Administrator has the following options:

Previous Topic

Next Topic

View Data Source Configuration Details

You can view detailed data source configuration information for debugging and support purposes.

To see detailed information on a data source

Select the Details menu option from the Data Source Configuration form.

The Data Source Configuration Details form, which is read-only, is displayed.

ODBCDataSourceCfgDetails

Previous Topic

Next Topic

Driver Configuration Options

The Ingres ODBC Administrator does not allow the installation or modification of driver information, except for tracing in an ODBC environment. The driver is typically installed when Ingres is installed, or can be set up after installation by using the iisuodbc or iiodbcinst utilities.

To see information about the installed drivers

Select the Drivers menu option from the Main Menu form.

The Installed Drivers Form is displayed:

ODBC Administrator - Installed Drivers

This form allows you to perform the following configuration tasks for each installed driver:

Previous Topic

Next Topic

Enable ODBC Tracing

The default mode for tracing is OFF.

To enable ODBC tracing

  1. Select Tracing on the Installed Drivers form.

    The Select ODBC Tracing form is displayed:

  2. Select Edit to toggle the mode to ON.
  3. Specify the path and file name of the tracing log file in the Trace Path field. You must specify a tracing log file. If no path is provided, the log is written to the directory in which the ODBC application executes.

The Driver Manager field displays the type of driver manager that was specified when the iiodbcinst or iisuodbc utility was executed.

Previous Topic

Next Topic

Select a Driver Path

You can use the default path configured for ODBC drivers, or set an alternate path.

To select a path for the driver definitions and system-level data source definitions

  1. Select Files on the Installed Drivers form.

    The Select Driver Files form is displayed:

  2. Select either the default path or an alternate path.

    To select the default path, place the cursor on SYSTEM and choose Select.

    To select an alternate path, place the cursor on the ALTERNATE option and choose Select.

    The Define Alternate Driver Path form is displayed:

  3. Enter in the Path field the path you want to use for the driver and select Save.

    The driver path is set.

    Important! This alternate path remains in effect only for the duration of the current ODBC Administrator session, or until another path and file name is defined for the data sources. You can change the default path with the iisuodbc or iiodbcinst utilities.

Previous Topic

Next Topic

View Driver Configuration Details

You can use the read-only form, Driver Configuration Details, to help in debugging and support-related tasks.

To view configuration details for a particular driver

Select the driver on the Installed Drivers form and select Details.

The Driver Configuration Details form is displayed:

ODBC Driver Configuration Details

Previous Topic

Next Topic

Select a Data Source Configuration File Path

You can select the default path configured for the user-level data source definitions, or specify an alternate path.

To select a data source configuration file path

  1. Select the Files menu option from the Main Menu form.

    The Data Source Files form is displayed:

  2. To select the default path, place the cursor on the USER or SYSTEM option and choose Select.

    The default path configured for the user-level data source definitions is selected.

    Note: Non-Windows environments can use any valid path for the driver configuration file, odbcinst.ini. The ODBC environment variable ODBCSYSINI defines the configuration file path. When running ODBC applications, we recommend that you define ODBCSYSINI, especially if the driver manager is CAI/PT or the Ingres ODBC CLI. Without this definition, unixODBC environments assume the driver configuration path is /usr/local/etc (SYS$SHARE on VMS). Use of the ALTERNATE path without defining ODBCSYSINI works only if the driver manager automatically uses this path.

    The USER represents a private definition for the individual, logged-in user, while SYSTEM represents a global definition applicable to all users on the platform.

  3. To specify an alternate path, place the cursor on the ALTERNATE option and choose Select.

    The Alternate Data Source Path form is displayed:

  4. Type over the path in the Path field with the alternate path and filename you want to use to access user-level data source definitions, and select Save.

    The alternate path is defined.

    Important! This alternate path remains in effect only for the duration of the current ODBC Administrator session, or until another path and file name is defined for the data sources.

Previous Topic

Next Topic

Test a Data Source Connection

After a data source has been defined and any changes have been applied, you should test the current settings for the data source to insure that a proper connection can be made through ODBC.

To test the connection for a particular data source

Select the data source name on the Main Menu form and select Test.

The ODBC Administrator attempts a connection to the configured vnode for that data source and returns a message indicating whether the connection was successful.

Previous Topic

Next Topic

Edit and Remove Data Sources

You can configure as many data sources as you require. Once defined, a data source is available for use by any application that uses ODBC.

To modify an existing data source configuration

  1. Select the data source in the ODBC Data Source Administrator Main Menu form and select Edit.

    The Data Source Configuration form is displayed.

  2. Edit the data source configuration by following the instructions described in the Configure a Data Source sections.

To remove an existing data source configuration

  1. Select the data source on the Main Menu form and select Destroy.

    A prompt asks you to verify the removal of the data source configuration.

  2. Reply in the affirmative.

    The data source definition is removed.


© 2007 Ingres Corporation. All rights reserved.