Date:         Sun, 16 Oct 2005 22:47:15 -0600
Reply-To:     Alan Churchill <SASL001@SAVIAN.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Alan Churchill <SASL001@SAVIAN.NET>
Subject:      htmSQL and IIS
In-Reply-To:  <OFFF064B2B.92E047D6-ONCA25709C.00806E00@workcover.vic.gov.au>
Content-Type: text/plain; charset="us-ascii"

This is for the archives and to simplify the life of people setting up
htmSQL on IIS.

The SAS docs state that you need to make a registry change to have IIS
automatically route hsql queries to the htmsql.exe. I was able to get this
working by just making a configuration setting in IIS.

In IIS
 ========================================================================

1. Right-click the individual Web site or the Web Sites folder, and then
click Properties.
2. On the Home Directory tab, click Configuration.
3. Under Application Configuration, click Add, and then click the Mappings
tab.
4. With the Add/Edit Application Extension Mapping dialog box open, click
Browse to select the .exe file or the .dll file from the local path on the
Web server.

Note You must type the path to a valid file in the Executable text box or
the OK button remains unavailable. The easiest way to make sure that you
enter a valid path is to select the file by using the Browse button.
5. After the path appears in the Executable text box, click in the
Executable text box to initialize the path.
6. Click in the Extension space, and then type the file name extension.

Note You must enter the period (.) in front of the extension in the
Extension text box, or the OK button remains unavailable.
7. When the OK button becomes active, click OK to continue.

 =======================================================================

If anyone knows if this is wrong for whatever reason, please let me know.


Alan Churchill
Savian "Bridging SAS and Microsoft Technologies"
www.savian.net