Setting the default database driver

With the introduction of the multi-database connection in Lycia the default database driver for runtime and compilation takes effect only if there is no corresponding driver specification in the database configuration file for the used database name.

When compiling programs using LyciaStudio

To set the database driver, start LyciaStudio and go to Window →Preferences → 4GL → Database. From here, the developer can choose between a number of databases without the need to recompile after every change. This dialog window modifies env.properties , Lycia configuration file that contains environment variables used at program compilation in LyciaStudio. LYCIA_DB_DRIVER acquires these values depending on the option selected:

• informix (default) - for the native connection to Informix® databases,
• oracle - for the native connection to Oracle® databases, and
• odbc - for enabling the general ODBC interface.

When running applications via LyciaDesktop or LyciaWeb

To be able to connect to a database at runtime, modify the value of LYCIA_DB_DRIVER in inet.env:

Refer here to learn how to edit this file.

Possible values are the same:

• informix (default) - for the native connection to Informix® databases,
• oracle - for the native connection to Oracle® databases, and
• odbc - for enabling the general ODBC interface.

For Command Line Tools

If you compile and run your programs using the command line environment, you must set the value of LYCIA_DB_DRIVER in environ.bat for and environ for environ:

Refer here to learn how to create and edit this file.

Possible values are the same:

• informix (default) - for the native connection to Informix® databases,
• oracle - for the native connection to Oracle® databases, and
• odbc - for enabling the general ODBC interface.

The database driver may also be set by appending the –DB flag to an application on the command line, this overrides the variables in the environment settings.