469,265 Members | 2,017 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,265 developers. It's quick & easy.

80004005 . . . .is not a valid path

Hi all,

I am getting the following error.

*****************************
Microsoft JET Database Engine error '80004005'

'O:\DATA\DSR\DSR_DATA.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.

/dsr.asp, line 18
*****************************

Here is what I have:

Webserver: Windows 2000 Server SP4, IIS 5.0, Novell Client 32, and
Gateway Services.

I can get to the O drive with explorer, Access is not installed on the
Webserver.

I have checked the rights on the Novell Server and the Webserver has
full rights except supervisor. I have also checked the rights on the
TEMP directory, everyone has rights to this folder, I even added more
users just to try, still no luck.

I think that is about it.

Thank you in advance for your help,

Rodger
Jul 19 '05 #1
19 8199
Rodger wrote:
Hi all,

I am getting the following error.

*****************************
Microsoft JET Database Engine error '80004005'

'O:\DATA\DSR\DSR_DATA.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.

/dsr.asp, line 18
*****************************


Have you checked this faq article?
http://www.aspfaq.com/show.asp?id=2009

This is definitely a permissions issue. Remember, the asp application is
running under the local IUSR account. See the faq for more details.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 19 '05 #2
Also http://www.aspfaq.com/2168 (O:\ is likely to be a mapped drive for
another machine, which IUSR most certainly isn't aware of.)

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eg**************@tk2msftngp13.phx.gbl...
Rodger wrote:
Hi all,

I am getting the following error.

*****************************
Microsoft JET Database Engine error '80004005'

'O:\DATA\DSR\DSR_DATA.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.

/dsr.asp, line 18
*****************************


Have you checked this faq article?
http://www.aspfaq.com/show.asp?id=2009

This is definitely a permissions issue. Remember, the asp application is
running under the local IUSR account. See the faq for more details.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Jul 19 '05 #3
Yes. A link to 2168 exists in 2009, but it is certainly more helpful to
reference the "real" article. I was being lazy.

Bob

Aaron Bertrand - MVP wrote:
Also http://www.aspfaq.com/2168 (O:\ is likely to be a mapped drive
for another machine, which IUSR most certainly isn't aware of.)
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eg**************@tk2msftngp13.phx.gbl...
Rodger wrote:
Hi all,

I am getting the following error.

*****************************
Microsoft JET Database Engine error '80004005'

'O:\DATA\DSR\DSR_DATA.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.

/dsr.asp, line 18
*****************************


Have you checked this faq article?
http://www.aspfaq.com/show.asp?id=2009

This is definitely a permissions issue. Remember, the asp
application is running under the local IUSR account. See the faq for
more details.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 19 '05 #4
> Yes. A link to 2168 exists in 2009, but it is certainly more helpful to
reference the "real" article. I was being lazy.


That's okay, lazy! ;-)
Jul 19 '05 #5
Bob,

Yes I have checked and the user signed on is WEBSRV3 and ISUR_WEBSRV3
has access to my mapped drive of O:\DATA\DSR\DSR_DATA.MDB. The System
DSN I have setup is pointing to this file. I have also tried a
DSN-less connection and get the same error. I have gon though the
FAQs and I have already tried each of them.

Any other ideas?

Thank you,

Rodger
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message news:<eg**************@tk2msftngp13.phx.gbl>...
Rodger wrote:
Hi all,

I am getting the following error.

*****************************
Microsoft JET Database Engine error '80004005'

'O:\DATA\DSR\DSR_DATA.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.

/dsr.asp, line 18
*****************************


Have you checked this faq article?
http://www.aspfaq.com/show.asp?id=2009

This is definitely a permissions issue. Remember, the asp application is
running under the local IUSR account. See the faq for more details.

Bob Barrows

Jul 19 '05 #6
Can you log in directly to the web server as IUSR_WEBSRV3 and see O:\ ?

(Hint: if you can't logon to the web server because you don't know the IUSR_
password, then you can't possibly have added an identical local user to the
machine where O:\ lives, which means IUSR doesn't have read/write
permissions to the remote share, which means you can't interact with the
database.)

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Rodger" <ro*******@hotmail.com> wrote in message
news:17**************************@posting.google.c om...
Bob,

Yes I have checked and the user signed on is WEBSRV3 and ISUR_WEBSRV3
has access to my mapped drive of O:\DATA\DSR\DSR_DATA.MDB. The System
DSN I have setup is pointing to this file. I have also tried a
DSN-less connection and get the same error. I have gon though the
FAQs and I have already tried each of them.

Any other ideas?

Thank you,

Rodger
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message

news:<eg**************@tk2msftngp13.phx.gbl>...
Rodger wrote:
Hi all,

I am getting the following error.

*****************************
Microsoft JET Database Engine error '80004005'

'O:\DATA\DSR\DSR_DATA.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.

/dsr.asp, line 18
*****************************


Have you checked this faq article?
http://www.aspfaq.com/show.asp?id=2009

This is definitely a permissions issue. Remember, the asp application is
running under the local IUSR account. See the faq for more details.

Bob Barrows

Jul 19 '05 #7
Dont databases on iis have to have the vitual directory location?
eh I dont know if you figure it out let us know.

"Rodger" <ro*******@hotmail.com> wrote in message
news:17**************************@posting.google.c om...
Hi all,

I am getting the following error.

*****************************
Microsoft JET Database Engine error '80004005'

'O:\DATA\DSR\DSR_DATA.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.

/dsr.asp, line 18
*****************************

Here is what I have:

Webserver: Windows 2000 Server SP4, IIS 5.0, Novell Client 32, and
Gateway Services.

I can get to the O drive with explorer, Access is not installed on the
Webserver.

I have checked the rights on the Novell Server and the Webserver has
full rights except supervisor. I have also checked the rights on the
TEMP directory, everyone has rights to this folder, I even added more
users just to try, still no luck.

I think that is about it.

Thank you in advance for your help,

Rodger

Jul 19 '05 #8
Aaron,

I am logged on as WEBSRV3 and yes I can see the O drive. I have
client32 installed for Novell. I thought that would help, but no
luck. I can browse to the database on the O drive. I have even tried
to reference the database in the ASP code with UNC with no luck. I
have this working on my other Webserver, but it is NT 4.0 with IIS
4.0.

Here is my code: (Note some lines are remed ' out . . . .)

<%@ Language=VBScript %>
<% Response.Buffer = true %>
<%
Dim conn, rs, rs2, mySQL, dbPath

dbPath = "O:\DATA\DAR\dsr data.mdb"
Set Conn = Server.CreateObject("ADODB.Connection")

conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=O\DATA\DSR\DSR DATA.mdb" ';User Id=admin;Password="

'Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath '&
";User Id=admin;"'& ";Persist Security Info=False"

'set conn = server.CreateObject("ADODB.Connection")
'conn.ConnectionString = "DSN=DSR"
'conn.Open

mySQL = "SELECT * FROM [COST CENTERS] ORDER BY CST_COST_CENTER"
set rs = conn.Execute(mySQL)

mySQL = "SELECT * FROM [COST CENTERS] ORDER BY CST_DEPARTMENT"
set rs2 = conn.Execute(mySQL)
%>
Thanks,

Rodger

"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message news:<OV**************@TK2MSFTNGP11.phx.gbl>...
Can you log in directly to the web server as IUSR_WEBSRV3 and see O:\ ?

(Hint: if you can't logon to the web server because you don't know the IUSR_
password, then you can't possibly have added an identical local user to the
machine where O:\ lives, which means IUSR doesn't have read/write
permissions to the remote share, which means you can't interact with the
database.)

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Rodger" <ro*******@hotmail.com> wrote in message
news:17**************************@posting.google.c om...
Bob,

Yes I have checked and the user signed on is WEBSRV3 and ISUR_WEBSRV3
has access to my mapped drive of O:\DATA\DSR\DSR_DATA.MDB. The System
DSN I have setup is pointing to this file. I have also tried a
DSN-less connection and get the same error. I have gon though the
FAQs and I have already tried each of them.

Any other ideas?

Thank you,

Rodger
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message

news:<eg**************@tk2msftngp13.phx.gbl>...
Rodger wrote:
> Hi all,
>
> I am getting the following error.
>
> *****************************
> Microsoft JET Database Engine error '80004005'
>
> 'O:\DATA\DSR\DSR_DATA.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.
>
> /dsr.asp, line 18
> *****************************

Have you checked this faq article?
http://www.aspfaq.com/show.asp?id=2009

This is definitely a permissions issue. Remember, the asp application is
running under the local IUSR account. See the faq for more details.

Bob Barrows

Jul 19 '05 #9
Rodger wrote:
Aaron,

I am logged on as WEBSRV3 and yes I can see the O drive.


YOU are logged in as WEBSRV3. ASP is not. Unless you have configured your
website to impersonate WEBSRV3, ASP is logged in as IUSR_WEBSRV3, which is a
local account on WEBSRV3. IUSR_WEBSRV3 will not have authority to look at
the O drive unless it is a domain-level account.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #10
I am not sure if I know what you mean?

"bob the yob" <bo*@hotmail.com> wrote in message
news:eP**************@TK2MSFTNGP09.phx.gbl...
Dont databases on iis have to have the vitual directory location?
eh I dont know if you figure it out let us know.

"Rodger" <ro*******@hotmail.com> wrote in message
news:17**************************@posting.google.c om...
Hi all,

I am getting the following error.

*****************************
Microsoft JET Database Engine error '80004005'

'O:\DATA\DSR\DSR_DATA.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.

/dsr.asp, line 18
*****************************

Here is what I have:

Webserver: Windows 2000 Server SP4, IIS 5.0, Novell Client 32, and
Gateway Services.

I can get to the O drive with explorer, Access is not installed on the
Webserver.

I have checked the rights on the Novell Server and the Webserver has
full rights except supervisor. I have also checked the rights on the
TEMP directory, everyone has rights to this folder, I even added more
users just to try, still no luck.

I think that is about it.

Thank you in advance for your help,

Rodger


Jul 19 '05 #11
Bob,

I ran FileMon http://www.sysinternals.com/ (free software that shows the
status of all files accessed by the machine it is running on) on both my
webserver and my workstation. And did not have any failures. Then I
decided to try opening the ASP page in question on the webserver, and it
opened just fine. Does this help any? I did talk to my network guy and he
told me about what you said, and that it is set right. Plus WEBSRV2 is
setup the exact same way.

Thanks again for you help,

Rodger

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:uJ**************@TK2MSFTNGP10.phx.gbl...
Rodger wrote:
Aaron,

I am logged on as WEBSRV3 and yes I can see the O drive.
YOU are logged in as WEBSRV3. ASP is not. Unless you have configured your
website to impersonate WEBSRV3, ASP is logged in as IUSR_WEBSRV3, which is

a local account on WEBSRV3. IUSR_WEBSRV3 will not have authority to look at
the O drive unless it is a domain-level account.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #12
> I ran FileMon http://www.sysinternals.com/ (free software that shows the
status of all files accessed by the machine it is running on) on both my
webserver and my workstation. And did not have any failures. Then I
decided to try opening the ASP page in question on the webserver, and it
opened just fine. Does this help any?
No.
I did talk to my network guy and he
told me about what you said, and that it is set right.


If it was "set right" you wouldn't be having errors, no?
Jul 19 '05 #13
Yes you are right I would not. Be we cannot find the one that is wrong.
If WEBSRV3 can run it locally then when I run it from a workstation hitting
WEBSRV3 I get the error, so then it is an issue with the Anonymous Access
even though the Anonymous User is WEBSRV3.
"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message
news:OP**************@TK2MSFTNGP10.phx.gbl...
I ran FileMon http://www.sysinternals.com/ (free software that shows the
status of all files accessed by the machine it is running on) on both my
webserver and my workstation. And did not have any failures. Then I
decided to try opening the ASP page in question on the webserver, and it
opened just fine. Does this help any?


No.
I did talk to my network guy and he
told me about what you said, and that it is set right.


If it was "set right" you wouldn't be having errors, no?

Jul 19 '05 #15
The article you're quoting has a user that can't connect to a DBF file via a
DSN on the local machine.

The original poster is using Access from a second machine and doesn't
require a DSN.

And no, "databases on iis DO NOT have to have the vitual directory
location"...

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"bob the yob" <bo*@hotmail.com> wrote in message
news:e4*************@TK2MSFTNGP11.phx.gbl...
http://www.experts-exchange.com/Web/..._20667330.html

Jul 19 '05 #16
I have already check the setting for the temp directories and that was not
the issue, but thatnks . . . .

"bob the yob" <bo*@hotmail.com> wrote in message
news:e4*************@TK2MSFTNGP11.phx.gbl...
http://www.experts-exchange.com/Web/..._20667330.html

Jul 19 '05 #17
Rodger wrote:
Bob,

I ran FileMon http://www.sysinternals.com/ (free software that shows
the status of all files accessed by the machine it is running on) on
both my webserver and my workstation. And did not have any failures.
Then I decided to try opening the ASP page in question on the
webserver, and it opened just fine. Does this help any?
Sorry, no.
I did talk
to my network guy and he told me about what you said, and that it is
set right.
What is "set right"?
Plus WEBSRV2 is setup the exact same way.


Unless your website is set up to impersonate WEBSRV2, the settings for
WEBSRV2 are irrelevant. IIS runs as IUSR_WEBSRV2 (ir WEBSRV2 is the name of
the computer, that is), unless impersonation is specified in the IIS Manager
settings for the website.

You mentioned Novell in your previous message. Did you read this article?
http://support.microsoft.com/?kbid=178045

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #18
Set Right meaning we did a compare of WEBSRV2 (which works) and WEBSRV3 both
the same and in the same groups. I did read the TID from Novell and we have
this set as they suggested.

Again I thank both you and Aaron for helping me sooooo much!!

I am going to mention your statment about impersonate again and see what
they tell me . . . .

Rodger
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eP*************@TK2MSFTNGP10.phx.gbl...
Rodger wrote:
Bob,

I ran FileMon http://www.sysinternals.com/ (free software that shows
the status of all files accessed by the machine it is running on) on
both my webserver and my workstation. And did not have any failures.
Then I decided to try opening the ASP page in question on the
webserver, and it opened just fine. Does this help any?
Sorry, no.
I did talk
to my network guy and he told me about what you said, and that it is
set right.


What is "set right"?
Plus WEBSRV2 is setup the exact same way.


Unless your website is set up to impersonate WEBSRV2, the settings for
WEBSRV2 are irrelevant. IIS runs as IUSR_WEBSRV2 (ir WEBSRV2 is the name

of the computer, that is), unless impersonation is specified in the IIS Manager settings for the website.

You mentioned Novell in your previous message. Did you read this article?
http://support.microsoft.com/?kbid=178045

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #19
ASP runs as an anonymous user. Do you understand the difference we are
trying to illustrate here?

You have a database on server A. A web server on server A. And a web
server on server B.

You are looking at server A, and saying "this server can connect to the
database file on server A. Therefore its settings must be correct."

Then you are looking at server B, and saying "this server has the same
settings as server A. Therefore it should be able to connect to the
database."

What you seem to be missing here is that ASP doesn't run as the same user
you are logging in as (what happens when a user requests a page after you
log out?). It runs as an anonymous user that is local to the machine
running the web server. In most cases, this is auser called
IUSR_servername. IUSR_servername on server A (let's call him IUSR_ServerA)
*only* has access to the web folders in the web site on server A. The
anonymous user running under the web service on server B (let's call him
IUSR_ServerB) *only* has access to the web folders in the web site on server
B. It can not just go out and read

The domain has no knowledge of IUSR_ServerA or IUSR_ServerB. Server A has
no knowledge of IUSR_ServerB. Server B has no knowledge of IUSR_ServerA.
Whether you have a user named WEBSRV2 or not is irrelevant... that's not who
ASP is executing as!

So, you have to synchronize these accounts in order for one local anonymous
account to be able to read/write to a folder on a different machine. Did
you look at http://www.aspfaq.com/2168 at all? Are you getting it yet? I'm
not sure how much more verbose I can get about this. The concept here has
been explained several times to various levels of detail but something is
getting lost on translation, between you and us, or between you and whoever
you're relaying this information to.

Or maybe you should make your life a little simpler and consider keeping the
database and the web application on the same machine. Or use a database
platform that is not so ridiculously tied to the file system...

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Rodger" <ro*******@hotmail.com> wrote in message
news:#5**************@TK2MSFTNGP12.phx.gbl...
Set Right meaning we did a compare of WEBSRV2 (which works) and WEBSRV3 both the same and in the same groups. I did read the TID from Novell and we have this set as they suggested.

Again I thank both you and Aaron for helping me sooooo much!!

I am going to mention your statment about impersonate again and see what
they tell me . . . .

Rodger

Jul 19 '05 #20

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Bryan Tang | last post: by
2 posts views Thread by ago | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.