Installation Notes

The zip file includes a .sql script file that will create the database tables.  This is the first thing that should be done before installing the windows based application or installing the web pages  on the server.  After the script has been run on your server, and the tables have been created, you are ready to install the windows based part of the application for IT Staff Members who will be using the windows application for updating requests, reporting and so on.   An ODBC DSN named AAHDPESQL will be created during the installation.  Because I don't know your server name/IP address, and your Login Name and Password you will need to modify the created DSN after installation and before running the program. 

To change the AAHPESQL data source, go to the Control Panel, Administrative Tools applet and then select Data Sources. Do not change the name of the DSN, but enter your server information and login credentials.  Before you get to this point you should have already used the script file to create the tables in your database. (NOTE:  See the section on the web interface if using the web pages.  In this release the connection string is not using the ODBC DSN name.  You will need to edit the common.asp file with your server/user/database details)

Click on the System tab and select AAHDPESQL and click the Configure button.

On the next screen, either type the Name of your Microsoft SQL Server or the IP Address of the server (you may also need to include the Port number, check with your DBA) and click the Next button.

The web pages that you may be using on the web server use a connection string in the file common.asp to establish the database connection.  See the additional help file for the web application by running setupweb.exe on your web server.

If you have problems or questions, write to me at either dennis@lnsoftware.com or dennis@dbandsons.com and I will try to get back to you promptly.