image\cslogo3d1.gif

Editing the Microsoft SQL Server Template

In order for developers to use DSN-less connection strings or file DSNs to connect an ASP application to a Microsoft SQL Server 7.0 database, you must specify the values for two parameters in the Microsoft SQL Server template section of the odbc.ini file. For the ServerIpAddress parameter, you must specify the IP address for the database server. For the ServerPortNumber parameter, you must specify the port number on which the database server is running.

In order to perform this procedure, you must be logged in as root on the computer running the Chili!Soft ASP Server.

To edit the Microsoft SQL Server template, use the following procedure.

To edit the Microsoft SQL Server template

1.   Stop Chili!Soft ASP Server, as described in "Stopping and Restarting the ASP Server" in this chapter.

2.   In the /casp directory, open the odbc.ini file in a text editor. This file is located in the following directory:

/[C-ASP_INSTALL_DIR]/asp-[WEB_SERVER]-[PORT]

where [C-ASP_INSTALL_DIR] is the path name of the Chili!Soft ASP installation directory, [WEB_SERVER] resembles apache, netscape, or zeus, and [PORT] is the ASP Server port number (resembles 3000). 

3.   In the [MSSQLServer_template] section of the odbc.ini file, specify the ServerIpAddress and ServerPortNumber values for the SQL Server 7.0 database you want to configure.

4.   Save your changes, and then restart the ASP Server, as described in "Stopping and Restarting the ASP Server" in this chapter.

See also:

Using File DSNs in "Chapter 4: Building a Chili!Soft ASP Application"

Using DSN-less Connection Strings in "Chapter 4: Building a Chili!Soft ASP Application"

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