Usage:
<Database Name=value Type=value Source=value Login=value Password=value Verify={0,1} Modify={0,1}>
Name
The name of the database.
Type
The type of the database. The values are not case-sensitive, and can be on of:
Postgres
- Connect to a PostgreSQL database.MySQL3
- Connect to a MySQL version 3 database.Oracle8
- Connect to an Oracle 8 database.NULL
- Tables defined in a NULL database are read-only references to CSV files. The Name property can be anything, and no other properties are needed. Use a NULL database to enumerate unchanging data, for example a list of English counties, or months of the year. The table definitions are different are different from the usual table definitions.Source
This tells Arcos where the database resides. Assuming that the database is installed correctly, the value "localhost" ensures that wherever it resides on the local machine, Arcos can access it. (Optionally, it can be left blank if the database is on localhost, that is, use Source=""
). To access a database on a remote machine use the external address.
Login
The username for the database.
Password
The password for the database.
Verify
Takes the following values:
0
- Assume that the database is correct. If any fields are missing from the definition, a failure will occur later.1
- Check that the database has the correct structure (that is, the field names in the database match the field names that you specify in the Field tag). Abandon the connection if the definition in the configuration file does not match the database structure.Modify
If the attribute is omitted, Arcos assumes a value of 0. We recommend that you always set the flag to 1 when you are developing the web site. Takes the following values:
0
- Do not allow Arcos to modify the database.1
- Allow Arcos to modify the database. Requires Verify="1". If a table structure is different to what we are expecting, try to correct it, keeping the data if possible (Arcos backs up old table, so that you can restore it if things go wrong). To allow modification, the global switch called CONST_EnableModify in the settings.ini.local file must be set to the value 1.