You are here:

4. Connect to the Database

4A. Ensure your Informix Database is Installed and Running

4B. Set the Database Driver (LYCIA_DB_DRIVER)

4C. Ensure That the Database-Related Environment Variables Are Set

4D. Verify the Database Data and Permissions

Note: In this chapter, we establish the connection to the Informix database. Lycia also supports connecting to other databases (including multiple databases). You can find the guides for those cases below:

4A. Ensure your Informix Database is Installed and Running

You can use an existing Informix database to work with Lycia or you can create a new one.

For details about the connection process, refer to the following page: Establish the Informix Connection

4B. Set the Database Driver (LYCIA_DB_DRIVER)

Lycia uses the Informix DB driver by default. If you want to use another database, specify it using the LYCIA_DB_DRIVER environment variable or the -d flag for command line tools.

For Runtime: Specify the value of LYCIA_DB_DRIVER in the inet.env configuration file.

Example: export LYCIA_DB_DRIVER=informix.

For Compilation: Set the LYCIA_DB_DRIVER variable in settings.json.

Example:

"lycia.buildOperations: DefaultBuildEnvironment": [

{"name": "LYCIA_DB_DRIVER", "value": "informix"}

4C. Ensure That the Database-Related Environment Variables Are Set

4D. Verify the Database Data and Permissions

Verify that the database has all required fields, schemas, and that a user with appropriate permissions has been created.

4E. Set Up the Client-Server Connection

Ensure the database server and client can communicate (e.g., check the network connectivity and ensure that the appropriate database drivers have been installed).

See next: 5. Specify the Location for Lycia Configurations