database.cfg

database.cfg is used to connect to databases.

QPM creates a template for database.cfg that can be modified by a 4gl developer.

This template is called template_database.cfg and is located in the default Lycia configuration folder:

C:\Program Files\Querix\Lycia\etc
/opt/Querix/Lycia/etc/

 

To create database.cfg, you must

  1. create a copy of template_database.cfg,
  2. move this copied file to your configuration folder specified by LYCIA_CONFIG_PATH,
  3. rename it to database.cfg, and
  4. change the default contents of the file in the way you need.

If you do not move your database.cfg to the configuration folder specified by LYCIA_CONFIG_PATH, it will be rewritten when you update Lycia.

 

Its structure when a database configuring should be as follows:

dbname {

driver = "dbtype"

source = "database"

username = "user"

password = "pwd"

}

The options listed above should have the following values:

A single database.cfg file may contain several database specifications without no limits for their number. Here is an example of this file containing two database specifications:

or_db {

driver = "oracle"

source = "stores"

username = "john"

password = "123456"

}

ifx_db {

driver = "informix"

source = "stores@ixserv"

username = "jane"

password = "567890"

}

 

Contact Us

Privacy Policy

Copyright © 2024 Querix, (UK) Ltd.