ASP error when uploaded ""An error occurred on the server when processing the URL"

I have the following code which is an ASP questionnaire using an Access
database. (I am using access as I have no choice!). Basically there is an
html form which submits the form to the page below and the code below
submits the data to the DB and redirects the user.

The code works locally on http://localhost or http://127.0.0.1 but when I
upload it to a site (I have tried a few and they all error) it says "An
error occurred on the server when processing the URL. Please contact the
system administrator."

I was thinking it may be as I am not putting the full path to the database
i.e. c:/pathname/questionnaire.mdb but as I have to FTP it and I don't have
access to the full path and cannot find out what it is.

Has anyone any ideas on what this problem is or how to overcome it?
Luke

Advertisements

"Luke" wrote in message news:c50l7j$2nacvj$-berlin.de...
: I have the following code which is an ASP questionnaire using an Access
: database. (I am using access as I have no choice!). Basically there is an
: html form which submits the form to the page below and the code below
: submits the data to the DB and redirects the user.
:
: The code works locally on http://localhost or http://127.0.0.1 but when I
: upload it to a site (I have tried a few and they all error) it says "An
: error occurred on the server when processing the URL. Please contact the
: system administrator."

Did you?

: I was thinking it may be as I am not putting the full path to the database
: i.e. c:/pathname/questionnaire.mdb but as I have to FTP it and I don't
have
: access to the full path and cannot find out what it is.

Response.Write(Request.ServerVariables("PATH_TRANSLATED"))

This will give you the physical path to the script. You can figure it out
from there.

Server.MapPath only references the path under the web root. Your database
should be located in an area not accessible virtually.

\db
\db\questionnaire.mdb
\webroot
\webroot\default.asp

If your db is in the area similar to the above, using the PATH_TRANSLATED
will give you the physical path. If it were:
d:\inetpub\domainname\webroot then your physical path to your db would be:
d:\inetpub\domainname\db

Share This Page

Welcome to The Coding Forums!

Welcome to the Coding Forums, the place to chat about anything related to programming and coding languages.

Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. You'll be able to ask questions about coding or chat with the community and help others.
Sign up now!