Background:
We have a simple web based application written in ASP with a MS Access backend which is used for furniture sales. The application was written in about 2005 and it runs on a XP Pro box running IIS 5.1. A few mods has been done to the code over time but it largely remains the same. It is a simple application insofar as there is no 'merchant side' to it. Users do not purchase the furniture item as such; rather, they are able to see our shipments of furniture from China and see photos of items within those shipments, and 'reserve' them under their logon name.
Issue to quote on:
The issue with the site is that it is Internet Explorer (IE) specific. Everything works with other browsers except one function. That function is the reservation of an item. The code written allows the user that has logged on to see photos and a basic description of a furniture item. If the user likes a piece and it is not already reserved they have the option of reserving the piece. The code prompts the user with a 'yes or no, do you want to reserve this item?' popup and if the response is yes, it proceeds to write an update to the database. It also updates the screen so that the item shows that it has been reserved. This works with IE but not with Firefox, or Chrome or Safari. We would like this rectified so that it works with as many browsers as possible, preferably all of the four above. You should be able to see this flaw in action on our demo site (see details for access below).
We do not want a major conversion of the system to ASP.NET or the like. We would like the system to run on the same platform it is running now; with mods done to ASP page(s) only. No schema changes should be needed to the database, but you are welcome to do so as long as they are not radical. I do not think this will be necessary.
The demo site can be viewed at:
[login to view URL]
logon is:
password: george
Feel free to tinker with the above site – it’s not our live site. It’s on my home PC. Email me if it doesn’t work because it means someone has shutdown my PC.
Once logged on you should be able to see a menu on the left. If you click on 'Current Shipments' and then open any listed shipment you should be able to see Details and Photos of furniture pieces. You should also be able to 'Reserve' an item that is not already reserved. This will work with IE but not with Firefox, Safari, Chrome. With Chrome, a popup does appear but does not function. With the other two browsers nothing happens when the user clicks on “Reserve this Item”.
Setting up the system on your server:
1. The scripts need to be laid down in a folder such as C:\inetpub\wwwroot\foldername or they can be in a virtual folder also.
2. The Access db is referenced by a physical path within the scripts (eg. C:\database\[login to view URL]). References to the path need to be edited in two files, namely [login to view URL] and global.asp. The engine provider is: Provider=Microsoft.Jet.OLEDB.4.0
• The opening script is [login to view URL], so: http://yourserver/pony/[login to view URL]
• Execute permissions on the scripts are not required, just read.
• The IUSR account in IIS will need full file permission control of the Access database.
• There are a few essential folders that reside under the scripts folder. The first is the ‘temp’ folder which is empty but needed. The other is the images folder which contains a subfolder named shipments in which subfolders containing the shipment photos reside.
• When a user logs out (using the logout button in the menu) the code generates two emails, one going to the user and one us. The email contains a blurb about what was purchased and needs an SMTP server. The smtp server config is set in the [login to view URL] file with the gmailsmtpserver variable (which currently is set to my ISP as gmailsmtpserver = "[login to view URL]")
Regards
Nick