Beginning ASP 3.0, Chapter 12 (Connect.asp).

Richard LaChance · June 30th, 2004, 03:43 PM

I have tried a variety of database paths with this page, and none of them work. I using a remote server and uploading via Dreamweaver. This message keeps showing up (with some variation, depending on how I write the path):

Microsoft JET Database Engine error '80004005'

'D:\WWWRoot\lastchance.info\www\session\database\M ovie2000.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/session/connect.asp, line 25

Can anybody help me? I've looked at every page in the ASP forum, and couldn't find anything that fixed this problem. . .

Thanks!

happygv · July 2nd, 2004, 01:14 AM

Hi Richard,

Check Server.MapPath() function and use relative path and .mdb file name as its parameter.

_________________________
- Vijay G
Strive for Perfection

qazi_nomi · July 5th, 2004, 01:36 AM

Can u post the code of the page here

Love 4 all

illuminata_sum · July 22nd, 2004, 03:01 PM

I am having a similar problem. Although the error code is different, I think it relates to the same issue: the path in the connection string. The book says to save the Movie2000 database file on the C: drive of your LOCAL computer, and that's the path referenced in the code of the Connect.asp example. When run, however, it produces a server error. At no point is the reader instructed to upload the database file to the server, which leads me to wonder whether code that's carried out on the server would have any way of finding a database file on the client machine - ? It seems like the db file should be uploaded to the server, and that the path is wrong - but I'm not sure how to fix it.

happygv · July 24th, 2004, 04:12 PM

Quote:

quote:At no point is the reader instructed to upload the database file to the server, which leads me to wonder whether code that's carried out on the server would have any way of finding a database file on the client machine

I don't have that book with me. But I assume that the book wouldn't have instructed the reader to upload to server, as it would have been written in a view that one would practice all that in a PC where IIS runs.

In your case, if you could upload the file to the server, you can do that. Else you can share your folder that has the mdb file use that in the connectionstring as the path - "\\yoursystem\sharedfoldername\your.mdb".

IMO, one would not prefer have the database file stored in the client, unless he faces problem in making changes to db from a remote system where IIS runs.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection