To add an SQL database by entering information directly into OPTIONS.ini (instead of using the Add Database dialog—see Adding a Database), add a line of text of the following form:

You must supply all fields. Use “-” for fields that do not have a value.

Following is an example:

In the example above, the databaseName is myDatabase, and both useClientCredentials and runQueriesConcurrently are false. All other fields are not specified.

For ODBC databases, use “-” for jdbcUrl and jdbcClassName. For JDBC databases these fields must be set.

See also Generating encrypted passwords for SQL data sources.