Can't Connect to a Database

Issue: I cannot connect to my Oracle or Sybase database.

Resolution: Make sure that the ServerName parameter for your Data Source Name (DSN) is set to point to the server that is running the client software for your database and not to the database server itself. For more information about configuring DSNs, see "Configuring Data Source Names (DSNs)," in "Chapter 3: Managing Sun Chili!Soft ASP."

Issue: I cannot connect to a DB2 database.

Resolution: If your DB2 database server is configured to run in a different locale than your ASP Server and Web server, you might get the following error message when trying to connect to it from an ASP page:

"There is no available conversion for the source code page "932" to the target code page "1252". Reason Code "1". SQLSTATE=57017"

To address this problem, create the DB2 database on a server configured for the same locale in which the Web server and the Sun Chili!Soft ASP Server are configured to run. For more information, see "Configuring International Support" in "Chapter 3: Managing Sun Chili!Soft ASP."