Administering DBMS

The DBMS application is administered from the Sun ONE ASP Administration Console. Administrators use the Administration Console to enable DBMS for use, specify an authorization key that unlocks the application, and specify the blob file-size limit.

To make DBMS available for users, Sun ONE ASP administrators must do the following:

Enable the DBMS application in the Sun ONE ASP Administration Console.

Choose an authorization key and provide it to users. This key unlocks the application for use (the key will be the same for all users).

The session timeout is set to 20 minutes by default. If the session expires, users will be prompted to log back in. This timeout setting is configured in the global.asa file for DBMS. Likewise, if the Sun ONE ASP administrator changes the authorization key, users will be prompted to log back in with the new key.

Specify the blob file-size limit.

Provide users with the URL needed to access DBMS. Typically this will be:

//[HOSTNAME]/dbms

where [HOSTNAME] is the hostname of the Web server configured to run with Sun ONE ASP.

The DBMS application cannot be used to create a new database. It is assumed that a MySQL server is available to which users can connect, and that a database exists on that server.

Open the Sun ONE ASP Administration Console by using the following URL:

http://[HOSTNAME]:[PORT]

where [HOSTNAME] is the hostname of the Web server configured to run with Sun ONE ASP, and [PORT] is the port on which the Administration Console is running (5100 by default).

The Server Management page displays.

In the left navigation pane, click Tools.

The Tools page displays.

To enable or disable DBMS, select or clear the Enable box for DBMS (DBMS is enabled by default).

In the Key box for DBMS, specify the authorization key that unlocks the application for use. This authorization key must be supplied to each user of the application. The key is configured as "password" by default. A new key should be chosen as soon as possible.

In the File size limit for blob column (bytes) box, specify the blob file-size limit. This setting limits the size of files users can upload into their databases.

This value defaults to the smaller of the following two values:

The maxlongfieldlength parameter for ADO in the Sun ONE ASP configuration file, casp.cnfg, which specifies the maximum long field length in bytes (see the [ADO] keyword). This value is set to 65535 by default. If the data passed to a database exceeds this limit, ADO will throw an error.

The Max. Transfer Size (Bytes) setting on the Components page in the Sun ONE ASP Administration Console. This setting specifies the maximum transfer size (in bytes) that can be uploaded using the Chili!Upload component. This value is set to 1000000 by default.

Caution Severe problems will result if either of these values is set extremely high (such as 50 MB for maxlongfieldlength or 30 MB for Max. Transfer Size).

Click Save to save your changes, or Cancel to revert to the settings that were last saved.