LYCIA_DB_DRIVER

Specifies the default database driver that will be used at runtime.

Syntax:

LYCIA_DB_DRIVER={informix, odbc, oracle}

Possible values:

Usage and examples:

By default, the Informix database driver is used at runtime.

If necessary, you can change the default database driver in several different ways:

→ by setting the LYCIA_DB_DRIVER environment variable in env.properties (for compilation), in inet.env (for runtime), and in environ.bat (if you use Lycia Command Line):

LYCIA_DB_DRIVER=oracle

→ by modifying the database.cfg file,

→ at runtime - by the CONNECT TO statement,

→ for compilation - in LyciaStudio in the Database preferences page.

Environment variables has the lowest precedence that is why the LYCIA_DB_DRIVER value will be overwritten by all other methods.

Related articles:

Compiling Requirements

CONNECT TO

Connecting to multiple databases

Passing parameters and using flags

Precedence of parameters

Setting the default database driver