Redirect a database connection

You can point an existing database results region to a different database by modifying the database connection. 

1. On the Tools menu, click Web Settings, and then click the Database tab.
2. Click the database connection you want to modify, and then click Modify.

   Note   If your database is password-protected, click Advanced in the Database Connection Properties dialog box. Then, type your user name and password in the boxes.

3. Under Type of connection, choose one of the following:

   A file or folder in the current web site

   1. Click File or folder in current web, and then click Browse.
   2. In the Files of type box, select the driver for the type of database you're connecting to.
   3. In the URL box, type the path to the file or folder containing the database, and then click OK. Or, use the Look in box and file list to navigate to the file or folder you want, and then double-click the file or folder in the list.
   4. Click OK twice.

   A System Data Source Name (System DSN) on a web server

   Only a web server administrator can create a System Data Source Name (System DSN) (system DSN: A system data source name is specific to a local computer. The system or any user with privileges can use a data source that is set up with a system DSN.) on a web server. If the web server doesn't contain a System DSN for the database you want to access, ask the web server administrator to define one and to ensure that you are assigned the correct permissions.

   1. Click System data source on web server, and then click Browse.

      The System Data Sources on Web Server dialog box is displayed. The list shows the System DSNs defined on the web server.

   2. Select the System DSN for the database you want to access, and then click OK.
   3. Click OK twice.

   A database server on a network

   1. Click Network connection to database server, and then click Browse.
   2. In the Type of database driver box, select the type of database driver you want to use to connect to the database server.
   3. In the Server name box, type the URL of the network server containing the database you want to access.
   4. In the Database name box, type the name of the database, and then click OK.
   5. Click OK three times.

   A database using a custom definition

   1. Click Custom Definition, and then click Browse.
   2. In the Files of type box, select a File DSN or a UDL file, or edit a connection string:
      • To select a File DSN or UDL file in the current web, click Browse. In the URL box, type the path to the File DSN or UDL file to which you want to connect, and then click OK. Or, use the Look in box and file list to navigate to the File DSN or UDL file you want, and then double-click the file in the list.
      • To edit a connection string, click Advanced. In the Connection string box, type the appropriate string to pass to the database driver to which you want to connect, and then click OK.

        Note   Do not use a File DSN to connect to a database file in the current web; the File DSN will contain file paths that are incorrect for the web server. Instead, create a database connection to a file or folder in the current web.

   3. In the Database name box, type the name of the database, and then click OK.
   4. Click OK three times.