When you select ODBC query as the import type, data is imported from an external database such as an *.mdb file.

Set the options as follows:

• Database DSN: you can enter a DSN, or an ADO string. Using an ADO string allows you to deploy your survey on CATI, CAPI Windows or web server without creating a DSN on each machine. Here is a typical SQL ADO connection string you can use in your questionnaire:
  
  Provider=sqloledb; Data Source=[Your SQL Server]; Initial Catalog=[SQL Database you want to use];Trusted_Connection=no;User Id=[SQL Login];Password=[SQL Login Password]
  
  For example:
  
  Provider=Microsoft.Jet.OLEDB.4.0;data source=C:QesMyDatabase.mdb;
  
  If you are using a Microsoft Access database, you can set an ADO string as follows:

  Provider= Microsoft.Jet.OLEDB.4.0;Data Source=c:Database1.mdb

  If your Access database is protected by a password, then, you need to provide the password in the connection string, for example:

  Provider= Microsoft.Jet.OLEDB.4.0;Data Source=c:Database1.mdb;Jet OLEDB:Database Password=askia;

  Note: As the ODBC imports and Start SQL routing are able to manage the ResPath, you can integrate an MDB file as a miscellaneous resource file into your QEX. This can, for example, allow you to manage a contact database for a CAPI Windows survey. In this situation, the connection string will be as follows:
  
  Provider= Microsoft.Jet.OLEDB.4.0;Data Source=??ResPath??Database1.mdb;

• Note: Your SQL query should be structured in the following way:
  
  SELECT [field] FROM [table] WHERE [condition]
  
  The different values that you can use in your SQL queries are:

  • "Text value (text of item in closed question or open question)": you should use '??Shortcut??', e.g.: SELECT Nom FROM Table1 WHERE PASS='??Pass??'
  • "Response order of closed question": you should use !!??Shortcut??!!, e.g. SELECT ID1 FROM Table1 WHERE DEP=!!??Dep??!!
  • "Numeric question": you should use ??Shortcut??. e.g. SELECT Nom FROM Table1 WHERE PASS='??Pass??'

• Make the question invisible when imported: select this option if you want the ability to ask the question even when it has not been specified in the received link.