Help is needed (ASP Errors)

[Digitalaxy]

I am workin i a small ASP application and it was completed and tested on my local server successfully. However, we had some errors When I uploaded it to the our webhosting company. Most of errors were fixed except one which I tried hard to get the error but noway.

I am using IE7 and the error is: HTTP 500 Internal Server Error

the code is:

<!--#INCLUDE FILE="clsUpload.asp"-->

<%

Dim objUpload
Dim strFileName
Dim strPath

imageID=request.querystring("imageID")

' Instantiate Upload Class
Set objUpload = New clsUpload

' Grab the file name
strFileName = objUpload.Fields("File1").FileName



' Compile path to save file to
strPath = Server.MapPath("images") & "\" & strFileName

' Save the binary data to the file system
objUpload("File1").SaveAs strPath

' Release upload object from memory
Set objUpload = Nothing



set con=Server.CreateObject("ADODB.Connection")
    con.mode = 3 ' adModeReadWrite
	con.Open("Driver={Microsoft Access Driver (*.mdb)}; DBQ="& server.MapPath("DB_Name.mdb"))
	
con.Execute "UPDATE Properties SET img1='"&strFileName&"' Where R_ID = "& imageID &""

Response.Redirect "pro_view_detail.asp?pro_id="&imageID

%>

the includes files:

[ArthurKay]

A few things...

1) Make sure your browser gives you the detailed server error, not just the "Friendly Error Message" that IE has turned on by default. Using Firefox will probably be useful, as it tends to give you the full error message by default (I think, anyways).

2) I believe your SSI include statement in the first line is wrong... try:

<!--#INCLUDE virtual="clsUpload.asp" -->

That probably won't fix your error, but that's the correct syntax for including a file

3) You don't declare all of your VB variables before initializing them... again, this may not fix the 500 error, but it's good practice. Be sure to declare "imageID" before using it.

Your best bet will be to get the full error message from either IE or Firefox... it will tell you exactly what line/character the error occurs, as well as a detailed error code. If all else fails, you can look up that code on Google.

[ArthurKay]

You probably also need single quotes around

 
... Where R_ID =' "& imageID &" ' "

as the quotes may be screwing that up