Query Section

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.

NameDescription
dsnData Source Name, configured from the control panel
filedsnfile that specifies connection parameters
drivername of the driver to connect through
servercomputer name to connect to ("." indicates current machine)
databasedatabase
dbqDatabase Qualifier, used to supply a directory for drivers that store tables as single files
useruser name for the data source (if required)
passwordpassword for the data source (if required)