'c:\data\acm.mdb' is not a valid path. Error

[lagc]

I have this error coming up all the time, and I see what the problem is that the folder path my side isnt the same server side, I think anyway. can anybody help.

Microsoft JET Database Engine error '80004005' 

'c:\data\acm.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. 

/CMS/[URL unfurl="true"]www/common/dbconn1.asp,[/URL] line 19

 

[SkipVought]

Hi,

Where does acm.mdb reside?

What application were you running when you got this error message?

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[lagc]

Hi,
This is the code

appurl = "/CMS" 

dbPath = "\data\acm.mdb"

imageuploadpath = Server.MapPath(appurl & "\[URL unfurl="true"]www\userimages\")[/URL]
imagewebpath = appurl & "/[URL unfurl="true"]www/userimages/"[/URL]

set whtConn = server.createobject("adodb.connection")
whtConn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath

Acm.mdb resides on this path:

http://mysite.co.uk/CMS/data/acm.mdb

As for application, I'm not exactly sure what you mean.

Ta

 

[SkipVought]

"As for application, I'm not exactly sure what you mean."

When you enter your code and run, what application are you in? It's not NotePad.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[lagc]

Sorry no its Dreamweaver, I was actually thinking you meant something different

 

[Olaf Doschke]

I'd say it's an asp skript, perhaps IIS. The site may be made with Dreamweaver as your development environment.

Try

dbPath = Server.Mappath(appurl & "\data\acm.mdb")

Anyway, the Server.Mappath() function is there to map relative paths to their absolute analogon at the server, and you already use it for images.

Bye, Olaf.

 

[lagc]

Ye thats it, it worked fine.

Thanks very much

 

[Olaf Doschke]

You're welcome.