The following items are specified in the query section. They are all related to the data source. If the data source is specified in either a System, User or File DSN it will only be necessary to specify the DSN and the SQL.
| Name | Description |
|---|---|
| dsn | Data Source Name, refers to a saved configuration |
| driver | name of the driver to connect through |
| server | computer name to connect to ("." indicates current machine) |
| database | database |
| dbq | Database Qualifier, used to supply a directory for drivers that store tables as single files |
| user | user name for the data source (if required) |
| password | password for the data source (if required) |
| sql | SQL statement to process |
An example query configuration might be: