Server.Mappath and _mmServerScripts problem

Forum|Forum|20 years ago
April 3, 2006
2 replies
654 views

Ok my problem is simple I know how to work with it but I'm sure there has to be a fix or its a bug.
Using dreamweaver 8, and this connection string...

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("ce_db.mdb")

it keeps telling me that D:\path\path2\_mmServerScripts\ce_db.mdb is not found
(duh of course i dont have it there, its here D:\path\path2\ce_db.mdb)
it runs fine on the website though!

now i do this Server.MapPath("../ce_db.mdb")
and it works in dreamweaver but the website tells me this

Microsoft JET Database Engine error '80004005'

Could not find file 'd:\path\ce_db.mdb'.

the only way i found to fix it its to change the connection everytime im done working with the database but that sucks

anyone knows how to fix it?

Server side applications

This topic has been closed for replies.

O

os_84Author

Participant

so no one knows?

W

wizardofdata

Participant

I have found that when developing locally, Dreamweaver (versions 6, 7, and 8) does not like the Server.MapPath. I always connect with an absolute path like so:

MM_products_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\man\products.mdb;"

(changing whatever your path and string name is)

Then, I go into my connections folder, add the relative (Server.MapPath) string, making sure I comment it out. When I am ready to upload to my server, I then un-comment the relative string and comment out the absolute string.

As far as your relative path, you may want to try it as:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../ce_db.mdb")

this way you're telling the script to look one folder higher than the _mmServerScripts folder DW is looking for.

Please advise if this is clear as mud or clear as crystal. Good luck and keep coding!

N

Newsgroup_User

Inspiring

Have you tried a site-root relative path? For example:

Server.MapPath("/ce_db.mdb")

Hope this helps,
Randy

> Ok my problem is simple I know how to fix it but Im sure there has to be a fix.
> Using dreamweaver 8,
> and this connection string...
> "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("ce_db.mdb")
> it keeps telling me that D:\path\path2\_mmServerScripts\ce_db.mdb is not found
> (duh of course i dont have it there)
> it runs fine on the website though!
>
> now i do this Server.MapPath("../ce_db.mdb") and the website tells me this
>
> Microsoft JET Database Engine error '80004005'
>
> Could not find file 'd:\path\ce_db.mdb'.
>
> the only way i found to fix it its to change the connection everytime im done
> working with the database but that sucks

O

os_84Author

Participant

that didnt work... gave me another directory

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.