Database Wizard – Document Type

Develop > Database > Document Properties – Document Type tab

In this step of the Database Wizard, you can specify the document type, the type of database connection, and the Web server operating system for a database-enabled document created using the Database Wizard.

Block type

The type of block used in the current document. This cannot be changed. If you need to use a different block type, create a new document and select the desired block type in the Database submenu of the Insert menu.

Script type

Choose the dynamic document standard you wish to use for the current document. The choices are ASP , PHP, and JSP.

  • ASP (Active Server Pages) is Microsoft’s proprietary standard for creating dynamically updated Web documents. Microsoft’s Web server programs, Internet Information Server (IIS) and Personal Web Server (PWS), have built-in support for ASP. On other platforms, ASP support is provided by third-party software such as Chili!Soft ASP.
  • PHP (PHP Hypertext Preprocessor) is an open source standard for creating dynamically updated Web documents. It is similar in function to ASP, but non-proprietary. PHP software may be freely downloaded from the PHP home page at http://www.php.net.
  • JSP (Java Server Pages) is very much like ASP except that the programming language is Java instead of VBScript or JavaScript. For more information about JSP, refer to http://java.sun.com/products/jsp.
Database

Specify the type of database that the current document will connect to. This actually determines how the document will connect to the database. The database types available in the menu depend on which script type is selected:

  • If the script type is ASP, the only available database type is ODBC. The document will use an ODBC connection to any database that supports ODBC.
  • If the script type is PHP, the available database types are ODBC and MySQL. Choose ODBC if you wish the document to use ODBC to connect to a database that supports it. Choose MySQL if the document will connect to a MySQL database and you wish to use a TCP/IP connection.
  • If the script type is JSP, the menu will list several database types (JDBC drivers). Select the type corresponding to your database. For example, if you are using an Oracle database, select Oracle. If your database type is not listed, select ODBC if you wish to use ODBC and the database supports it; otherwise, select User-defined. If you select User-defined, you will need to specify the driver to be used to connect to the database in the next step of the Database Wizard.
Server OS

Specify the operating system of the Web server that will serve the current document. If the document contains a chart block, this setting is used to determine the appropriate CGI program that will be uploaded to the server along with the document. If the document does not contain a chart block, this setting is ignored.

Database Wizard – Document Type