Microsoft JET Database Engine path error

bean_2k1 · January 24th, 2007, 05:35 AM

Hi all, my boss has asked me to see if i can update our website, it is done in asp and access, basically i have put it on a test server but everytime i keep trying to view the admin and products page and i keep getting

Error Type:
Microsoft JET Database Engine (0x80004005)
'W:\webs\Hosted_Sites\www.towelrails2go.com\databa se\towelrails2go.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.
/www/products2.asp, line 41

Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)
Page:
GET /www/products2.asp

would anyone know which file i need to edit to change the path of the database from 'W:\webs\Hosted_Sites\www.towelrails2go.com\databa se\towelrails2go.mdb' to '..\database\towelrails2go.mdb'

snow · January 24th, 2007, 10:00 AM

Depends how it was set up I believe (I've never really used asp, just the .net variety)... I'd check out your web.config file though...

spinal007 · January 24th, 2007, 10:32 AM

basically, the database driver cannot find the database file.

either, it's not in this folder:
W:\webs\Hosted_Sites\www.towelrails2go.com\database\

OR, it's not called:
towelrails2go.mdb

also, you had a space in the file path:
databa se\

I'm not sure if that was just an error on your post or in your application.

Either way, you should use Server.MapPath(VIRTUAL_PATH_TO_DATABASE) to avoid these errors

To fix this, start by looking at the /www/products2.asp file on line 41.

bean_2k1 · January 26th, 2007, 03:49 AM

thanks alot for the advice i will see what i can do toda hopefully i will have it working today