Setting up Database Connections

The Database page enables you to define databases you want to access with AskAnywhere.  For example, you may want to have your questionnaire access a specific database in order to check that a password entered by a respondent is a valid password for your questionnaire.  (For more information about using these database connections in your questionnaires, refer to the Using Database Queries in Adaptive Tags section of the AskAnywhere Editor User's Guide.)  You can access ODBC, MySQL, and Oracle databases.  The drivers for these types of databases are already loaded as part of the AskAnywhere software.

Adding Database Connections

To add a new database connection for AskAnywhere, complete the following steps.

1. From the Database page, select Add New Connection.



2. The following screen appears.  Enter the desired information and select Add This Connection.
   • The Connection Name field contains the name of the connection.  This must be a unique, alphanumeric value.
   • The Database Address (URL) field contains the address of the database server you want this connection to access.
     • For MySQL, this field is in jdbc:mysql://serverdomain/database format, where “serverdomain” is the IP address of the desired server and “database” is the name of the desired database.
     • For Oracle, this field is in jdbc:oracle:thin:@serverdomain:####:database format, where “serverdomain” is the IP address of the desired server, “####” is the port that Oracle should listen to, and “database” is the name of the desired database.
   • The User Name field contains the user name used to log in to the database.
   • The Password field contains the password associated with the previous user name.
   • The Re-type Password field contains the password for verification purposes.

Editing Database Connections

To edit a database connection for AskAnywhere, from the Database page, select the desired connection from the Connection drop-down menu.

• To change the database address, enter the new database address in the Database Address (URL) field and select Save.
• To change the user name used to log in to the database, enter the new user name in the User Name field and select Save.
• To change the password, enter the new password in the Password and Re-type Password fields and select Save.  Note:  Passwords will not appear on the screen.  If you leave the password fields blank, the system will not change the existing password.
• To clear all the values on the screen, select Reset.

Deleting Database Connections

To delete a database connection, complete the following steps.

1. From the Database page, select the desired connection from the Connection drop-down menu.



2. Select Remove xxx (where “xxx” is the name of the database connection).

Viewing Database Connections

1. To view a list of established database connections, select View Established Connections.



2. To view list of all database connections (whether loaded in memory or not), select View All Connections.

Setting up Projects | Table of Contents | Accessing Survey Data