Specifies the base ODBC connection string for the database connection.
Syntax:
ODBC_DSN={DSN name}
Usage:
The ODBC_DSN environment variable 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
Related articles:
Setting up SQL Server connection