Installation Notes

The default installation should be accepted in most cases. However, if you have the full version of Crystal Reports installed, you might want to choose the custom installation and deselect the runtime files. Also, if the computer you are installing the program on will NOT be also serving the web pages, you might want to de-select the web pages installation.

When multiple technicians will be using the program in shared mode, it will be necessary for them to move one of the aahdpro2.mdb files to a location on a common server. Then, using the ODBC Applet in control panel, they will each need to modify the DSN AAHDPR02 to point to the location of the shared database - aahdpro2.mdb

The default installation will place the database file in c:\inetpub\wwwroot\aahdpro2 - the data file format is the same for all versions of AccessAble Help Desk Pro Edition 2.0 thru 2.5 - Changes may be made to the database structure whenever I release version 3.0. NOTE: I have added one table to the database in this release - peripheral types, with one field, PeripheralType, Char 22. If you are upgrading from version 2.0 - 2.57 but don't want to import your data, you may want to manually add this table to your aahdpro2.mdb file. Email me if you need more information.

While the windows application and the Crystal Reports use the ODBC DSN to connect to the database, the web interface uses a DSN-Less connection as specified in the common.asp file - please see the section on the web interface for more information on setting up and using the web pages. While you can use any HTML editor to modify the .html pages, I recommend using only Notepad.exe to edit the .asp pages. You will need at least to make some changes to the common.asp file - especially if the database is not going to be in the expected directory - c:\ineptub\wwwroot\aahdpro2

Because I can't know the IP address of host name of your web server, I have the server url as localhost. So, open the file common.asp and look for the line below. Replace localhost with your server ip address, or maybe domain name:

ServerURL = "http://localhost/pro259/"

The database connection is also set in the common.asp file, so look for and modify if needed the lines below in the common.asp file:

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Inetpub\wwwroot\aahdpro2\aahdpro2.mdb;Persist Security Info=False"
User = "Admin"
Password = ""

In some of the web pages, I have lines which would enable the automatic sending of email using CDO.SYS Lines where CDO is called would need to be modified. Anyway, I have remarked out with a single quote ' lines which would send email If you want to try sending email from the server, you would remove the single quote and put in your email address instead of dennis@lnsoftware.com

First, the section below is from the createaccount_events.asp file:


''!! Send Email @11-F1BAC9B1 - remove the ' from the lines below and edit as needed '
' Dim sch, cdoConfig, cdoMessage
' sch = "http://schemas.microsoft.com/cdo/configuration/"
' Set cdoConfig = Server.CreateObject("CDO.Configuration")
' With cdoConfig.Fields
' .Item(sch & "sendusing") = 2 'cdoSendUsingPort
' .Item(sch & "smtpserver") = "yoursmtpserver name or IP address"
' .Update
' End With
' Set cdoMessage = Server.CreateObject("CDO.Message")
' On Error Resume Next
' With cdoMessage
' Set .Configuration = cdoConfig
' .From = Users.Email.Text
' .To = "you@yourdomain.com"
' .Subject ="New Account Created"
' .TextBody = "Your Web Login name is: " & Users.WebLogin.Text & " and your password is: " & 'Users.WebPassword.text
' .Send
' End With
' Set cdoMessage = Nothing
' Set cdoConfig = Nothing
' On Error Goto 0
' ! End Send Email - remove the ' from the lines above and edit as needed

The above would send an email to the person who created the account with their login name and password for the web pages.

Next, you might want to try the Myrequest_events.asp page:

''! Send Email @28-7EF58997 - remove the ' from the lines below and edit as needed
' Dim sch, cdoConfig, cdoMessage
' sch = "http://schemas.microsoft.com/cdo/configuration/"
' Set cdoConfig = Server.CreateObject("CDO.Configuration")
' With cdoConfig.Fields
' .Item(sch & "sendusing") = 2 'cdoSendUsingPort
' .Item(sch & "smtpserver") = "yourmailservername or ip address"
' .Update
' End With
' Set cdoMessage = Server.CreateObject("CDO.Message")
' On Error Resume Next
' With cdoMessage
' Set .Configuration = cdoConfig
' .From = Requests1.Details.Text
' .To = "you@yourdomain.com"
' .Subject = "New Request"
' .TextBody = Requests1.Details.Text
' .Send
' End With
' Set cdoMessage = Nothing
' Set cdoConfig = Nothing
' On Error Goto 0
'! End Send Email - remove the ' from the linese above and edit as needed

This is intended to send an email to the person requesting support as well as hard coded email address (you or a staff member) when a request is submitted.


You will want to be sure to always keep backup copies of the .asp/.html pages before making any modifications. If you need help, send email to dbandsons@aol.com