ODBC_DSN

Specifies the base ODBC connection string for the database connection.

Syntax

ODBC_DSN={DSN name}

Usage

ODBC_DSN specifies the base ODBC connection string for the database connection.

If ODBC_DSN is not set, the database name specified in the DATABASE statement will be used as the DSN name.

If ODBC_DSN is set, any parameter, specified in ODBC_DSN will be used instead of the one specified in the odbc.ini file. Except for the Driver parameter, which is set in the odbc.ini file.

ODBC_DSN applies at runtime (inet.env) and at compilation (env.properties).

Example:

Specifies the following ODBC connection string:

ODBC_DSN=DSN=mysql;USER=informix;Password=123456;Database=dbname