Configuring the Client Tier

This section discusses options for configuring your web browser to use iSQL*Plus. Specific topics discussed are:

• Adding MIME Types

• Adding Proxy Server Exceptions

Note that your network and browser configuration may not require you to change any settings in your web browser.

Adding MIME Types

Some web browsers may require you to either remove a MIME type definition or application association for files with a .SQL extension, or to create a MIME type or application association for files with a .SQL extension in order to load scripts into iSQL*Plus.

For example, to set up an application extension for files with a SQL extension in Netscape Navigator 4.7 for Windows NT:

1. Select Preferences from the Edit menu.

2. Select Applications from the Navigator menu tree.

3. Click the New Type button. On the displayed form, enter
   Description of type: SQL files
   File extension: SQL
   MIME type: text/plain
   Application to use: notepad.exe
   Uncheck the "use this MIME as the outgoing default for this extension"

If this is not set up in your web browser, you may get an error when you try to load scripts that iSQL*Plus cannot identify as text files.

Adding Proxy Server Exceptions

Some configurations of proxy servers may affect the ability of the iSQL*Plus user interface to connect with the iSQL*Plus Server. If you cannot connect with the iSQL*Plus Server, a browser alert "Document contains no data" is displayed when you try to load the iSQL*Plus Log In screen. If this situation occurs, you should reconfigure your proxy server or create a proxy exception in your browser for the Oracle HTTP Server running iSQL*Plus.

To configure the proxy exceptions setting in Netscape Navigator 4.7 for Windows

1. Select Preferences from the Edit menu.

2. Select Proxies from the Advanced category.

3. Select the Manual proxy configuration radio button.

4. Click View. The Manual proxy configuration dialog is displayed.

5. Enter the Oracle HTTP Server domain for which you do not want to use a proxy in the Exceptions pane.

To configure the proxy exceptions setting in Microsoft Internet Explorer 5.0

1. Select Internet Options from the Tools menu.

2. Click Lan Settings in the Lan Settings pane on the Connections tab.

3. Click Advanced in the Proxy Server pane. This is only available if Use a proxy server is selected.

4. Enter "*." followed by the Oracle HTTP Server domain for which you do not want to use a proxy in the Exceptions pane. For example, to enter an exception for the Oracle HTTP Server domain, host.domain, you must enter *.host.domain.