▪Database questions require that the appropriate drivers are installed. For example, a database driver that is available on a client workstation may not be available on the UNICOM Intelligence Interviewer - Server Admin. You must ensure that the database drivers used to create questions are also available on the server.

▪Databases that are available on one network may not be available on another network. You must be aware of the availability of a database when you work on multiple networks. The database that is used to create a database question must be available on the same network as the Interviewer Server.

▪You must ensure that the DSNs, used to setup the connection strings on the local workstations, point to the same database or file on the Interviewer Server.

▪The default error handler for database connections monitors whether the connection string returns any categories. If the question is not required to be answered, the error handler logs the error and the respondent will be automatically advanced to the next question. If the question must be answered, the error handler presents an error to the user and does not allow the user to continue with the survey. Script writers are encouraged to write custom scripts to handle these errors. All connections must be checked before you start the interview, and then respondents are asked to return when the survey is ready.

▪When an Excel spreadsheet does not include a named range, the sheet name can be used as the database question's table name. When you create database questions in Author, both the named range and the sheet name can be used as the database question's table name.

▪Translations are not provided for database items. You can create a different set of database questions for each language you want to use.

▪To use Microsoft Excel as a data source for database questions, you must have a defined range on one worksheet. To define a range: