Connecting To a Database
Lycia allows your application to connect to several databases at once. This is achieved by means of the database configuration file which stores all the valid database connections, and the CONNECT TO statement which unlike the DATABASE statement allows multiple database connection.
If you migrate your applications from the earlier versions of Querix products and do not plan to use the multiple database connection, you do not need to perform any changes either in your environment, or in your code. For the legacy projects migrated to Lycia, the corresponding environment variables and settings will be used, if the database is not found in the database.cfg file.
To connect to a database in Lycia, do the following:
Step
1. Set up the
connection between the database server and the database client.
This topic describes how to do it for Informix, Oracle and ODBC connections with the SQL Server as an example.
Step 2. Add the database connection details to database.cfg.
Step 3. Use the DATABASE statement in an application to connect to a single database and use the CONNECT TO statement to connect to several databases simultaneously.
Step 4. Set up the database driver. It will be used at compilation and runtime, if the database connection details for the database name referenced by the application were not found in database.cfg.