The DB connectivity tab looks like this:
Here you can select the following options:
Database type: select the type of the database for your survey. There are two database types available: Microsoft Access
When you choose this database type, a MDB database file that stores
responses is created locally.
My SQL
When you choose this database type, the database that stores the responses is a MySQL server (that can be a local server, or a remote server). Connectivity is made through direct TCP/IP connection. So if the MySQL server is remote, you should be authorized to connect remotely to it.
Database name: the name of the database that is created.
If the MySQL database type is selected, two panels are activated (in
Microsoft Access these panels are deactivated):
Connectivity for the program
Here you have four fields:
IP of DB server - IP or name of the database server
Port - the default value is 3306
User name
Password
The information provided in those fields is required when the database
is created.
Connectivity for the scripts
IP of DB server - IP or name of database server as they are written in the scripts (by defaul local host ).
Port - by default 3306
User name - by default the value entered in the User name field of the connectivity for the program panel
Password - by default the value entered in the Password field of the connectivity for the program panel
These details are relevant for the creation of the scripts that handle the responses and operate modifications on the database, as well as for the remote creation of the database.