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: