My ASP works in my IIS but NOT IN my web host server

[estillore]

I've written an MS Access driven ASP and tested it in my IIS.
It works well!! But it doesn't in my free web host server.

I believe I uploaded all the files (i.e. asp files, images, INCLUDING MY DATABASE) properly.

The brower gives me "HTTP 500 - Internal server error"

Can you help me figure out the problem?

[estillore]

I've written an MS Access driven ASP and tested it in my IIS.
It works well!! But it doesn't in my free web host server.

I believe I uploaded all the files (i.e. asp files, images, INCLUDING MY DATABASE) properly.

The brower gives me "HTTP 500 - Internal server error"

Can you help me figure out the problem?

Aside from HTTP 500 error, my web host server givers me the following errors:

Microsoft JET Database Engine error '80004005'

Could not find file 'g:\b\Grading System.mdb'.

/estillore/teachersgradeli st.asp, line 118

HELP PLEASE!!!

[KittenKoder]

You are pointing to a database on your local system (the G:\ drive). Obviously once you have uploaded it to the internet it has no idea where your G:\ drive is. It'll be looking for a G:\ drive on the server...

Replace your connection string with a relative path.

[estillore]

You are pointing to a database on your local system (the G:\ drive). Obviously once you have uploaded it to the internet it has no idea where your G:\ drive is. It'll be looking for a G:\ drive on the server...

Replace your connection string with a relative path.

Thanks for the reply but I've already done that. It still doesn't work!!! The browser still gave me the same errors.


estillore

[KittenKoder]

Post the code you are using. There's no way people can see what you are doing wrong otherwise.

[estillore]

Oh!!! Sorry...Anyway, here's the code (where I think an error occurs) for binding my scripts and my database.:

<%
xDb_Conn_Str = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" & Request.ServerV ariables("APPL_ PHYSICAL_PATH") & "Grading System.mdb" & ";Jet OLEDB: Database Password=admin; "
%>

N.B. My asp files and my database are on the same directory.

Thanks :-)
estillore

[jhardman]

<%
xDb_Conn_Str = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" & Request.ServerV ariables("APPL_ PHYSICAL_PATH") & "Grading System.mdb" & ";Jet OLEDB: Database Password=admin; "
%>

This may be very naive of me, but I can never remember when a space messes up file systems. I would try renaming the file "gradingSystem. mdb" just to be sure. It has always seemed to be system dependent.

Hee hee. Now everyone sees how much of a novice I am.