Setting JSP connection dialog box options

The purpose of this dialog box is to create a database connection for a JSP application.

To create a database connection:

1. Enter a name for the connection.

   NOTE

   Do not use any spaces or special characters in the name.

2. Enter the driver’s connection parameters.

   For examples, see JDBC connection parameters. For driver-specific requirements, see the driver vendor’s documentation or consult your system administrator.

3. Specify the location of the JDBC driver you want to use.
   • If your JDBC driver is installed on the same computer as Dreamweaver, select the Using Driver On This Machine option.
   • If your JDBC driver is not installed on the same computer as Dreamweaver, select the Using Driver On Testing Server option.

     NOTE

     Macintosh users can ignore this step because all database connections use the application server.

4. If you want, restrict the number of database items Dreamweaver retrieves at design time by clicking Advanced and entering a schema or catalog name.

   For more information, see Restricting database information displayed in Dreamweaver.

   NOTE

   You cannot create a schema or catalog in Microsoft Access.

5. Click Test.

   Dreamweaver attempts to connect to the database. If the connection fails, double-check the JDBC connection parameters. If the connection still fails, check the settings for the folder Dreamweaver uses to process dynamic pages (see Specifying where dynamic pages can be processed).

6. Click OK.

   The new connection appears in the Databases panel.

Related topics

• Obtaining a JDBC driver for your database
• JDBC connection parameters
• Connecting through an ODBC driver