I have version .97.3 installed on a Windows Server 2008 machine. All admin functions work, except for viewcat.asp, which displays an internal server error? Has anyone had this problem before?
I downloaded the application again and replaced the viewcat.asp file, same error.
Problem resolved. After looking at the file viewcat.asp and the tblUsers entries, I found that the below query was returning the error because one of the category rep_id values was not found in the sid column of the tblUsers, which was causing it to return an empty recordset.
Set repRes = SQLQuery(cnnDB, "SELECT uid FROM tblUsers WHERE sid=" & rstCategories("rep_id"))
If you're using IE turn off 'show friendly http errors' and you may see something more descriptive of the error. I haven't used IIS7, I've read the web server may not send detailed error information to the browser without a setting change somewhere, but the error information should be logged somewhere on the server.
Doug G
I'm sorry it took me so long to respond to your reply Doug G. I tried that but got the same error message.