image\cslogo3d1.gif

Testing a DSN

When you have finished adding a new system DSN or editing its information, you can use the following procedure to verify that it is functioning correctly.

To test a system DSN

1.   If necessary, open the Chili!Soft ASP Administration Console by using the following URL:

http://[HOSTNAME]:[PORT]

where [HOSTNAME] is the hostname of your Web server and [PORT] is the port on which the Administration Console is running (5100 by default).

22.   On the ASP Server tab of the Server Management page (the first page to appear when you open the Administration Console), click Databases.

image\databases_c.gif

The Data Source Names page displays.

23.   In the same line as the name of the DSN you want to change, click test.

image\dsn_test_c.gif

A dialog box displays providing information about the connection. If it reveals an error, correct the problem, and then retest the connection.

image\test_dsn.gif

Note

If you are running Chili!Soft ASP 3.6 with a Zeus Web server, and the test fails, it could be because the Web server hostname is not configured correctly. When you configure a Zeus Web server to run with Chili!Soft ASP 3.6, you should NOT use the fully qualified domain name ("server address") for the Web server hostname. Instead, use the hostname alone. For example, do not use this: hostname.domain.com. Instead, use this: hostname.

If your Zeus Web server is configured with the server address rather than the hostname alone, you can test a DSN by using the SQLEXECUTE diagnostic included with Chili!Soft ASP. For more information, see "Accessing Documentation, Samples, and Diagnostics" in "Introduction: About This Documentation."

See also:

Configuring Data Source Names (DSNs) in this chapter

Adding a DSN in this chapter

Editing a DSN in this chapter

Removing a DSN in this chapter

Copyright 2001 Sun Microsystems, Inc. All rights reserved. Legal Notice.