Database Wizard – Data Source (PHP+MySQL)
Develop > Database > Block Properties > Data Source tab
If you specified PHP as the script type and MySQL as the database type in the first step of the Database Wizard, this dialog box is used to specify the MySQL host name or IP address and the database name. Namo WebEditor needs this information in order to set up the database-enabled document to connect to the MySQL database through TCP/IP.
MySQL host
Enter the host name or IP address and port number where the MySQL database resides.
Example:
If the host name of the server hosting the database is “mysql.namo.com” and the port number is 3306, you would enter:
mysql.namo.com:3306
MySQL DB name
Enter the name of the MySQL database.
User ID
Enter the user ID you use to access the database.
Password
Enter the password you use to access the database.
You can complete the Database Wizard even without supplying a user ID and password to your data source. However, if you do not supply a user ID and password, you will not be able to preview your database-enabled document in Namo WebEditor’s Preview window.
ODBC DSN for preview
Even if you use JDBC to connect to your database, you must also specify an ODBC DSN (Data Source Name) to the same database. This is because Namo WebEditor always uses ODBC internally to discover the names and types of the fields in the database, for use in later steps of the Database Wizard as well as database-related dialog boxes.
If you have already set up an ODBC DSN for your database, select it from the drop-down menu. Otherwise, select <Make New DSN> and follow the steps in the Create New Data Source dialog box to set up a new ODBC DSN.
If you are unable to log in to your database, make sure the appropriate ODBC driver is installed on your computer and that the database connection setup information has been properly specified in the ODBC Data Source Administrator dialog box.