80004005 . . . .is not a valid path

[Rodger]

Hi all,

I am getting the following error.

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

'O:\DATA\DSR\DS R_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

[Bob Barrows [MVP]]

Re: 80004005 . . . .is not a valid path

Rodger wrote:[color=blue]
> Hi all,
>
> I am getting the following error.
>
> *************** **************
> Microsoft JET Database Engine error '80004005'
>
> 'O:\DATA\DSR\DS R_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
> *************** **************[/color]

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.

[Aaron Bertrand - MVP]

Re: 80004005 . . . .is not a valid path

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]" <reb01501@NOyah oo.SPAMcom> wrote in message
news:egZAnOnPEH A.3460@tk2msftn gp13.phx.gbl...[color=blue]
> Rodger wrote:[color=green]
> > Hi all,
> >
> > I am getting the following error.
> >
> > *************** **************
> > Microsoft JET Database Engine error '80004005'
> >
> > 'O:\DATA\DSR\DS R_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
> > *************** **************[/color]
>
> 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.
>
>[/color]

[Bob Barrows [MVP]]

Re: 80004005 . . . .is not a valid path

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:[color=blue]
> 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]" <reb01501@NOyah oo.SPAMcom> wrote in message
> news:egZAnOnPEH A.3460@tk2msftn gp13.phx.gbl...[color=green]
>> Rodger wrote:[color=darkred]
>>> Hi all,
>>>
>>> I am getting the following error.
>>>
>>> *************** **************
>>> Microsoft JET Database Engine error '80004005'
>>>
>>> 'O:\DATA\DSR\DS R_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
>>> *************** **************[/color]
>>
>> 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.[/color][/color]

--
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.

[Aaron Bertrand - MVP]

Re: 80004005 . . . .is not a valid path

> Yes. A link to 2168 exists in 2009, but it is certainly more helpful to[color=blue]
> reference the "real" article. I was being lazy.[/color]

That's okay, lazy! ;-)

[Rodger]

Re: 80004005 . . . .is not a valid path

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]" <reb01501@NOyah oo.SPAMcom> wrote in message news:<egZAnOnPE HA.3460@tk2msft ngp13.phx.gbl>. ..[color=blue]
> Rodger wrote:[color=green]
> > Hi all,
> >
> > I am getting the following error.
> >
> > *************** **************
> > Microsoft JET Database Engine error '80004005'
> >
> > 'O:\DATA\DSR\DS R_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
> > *************** **************[/color]
>
> 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[/color]

[Aaron Bertrand - MVP]

Re: 80004005 . . . .is not a valid path

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" <rodgerdjr@hotm ail.com> wrote in message
news:17e4c2b6.0 405200959.14e30 704@posting.goo gle.com...[color=blue]
> 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]" <reb01501@NOyah oo.SPAMcom> wrote in message[/color]
news:<egZAnOnPE HA.3460@tk2msft ngp13.phx.gbl>. ..[color=blue][color=green]
> > Rodger wrote:[color=darkred]
> > > Hi all,
> > >
> > > I am getting the following error.
> > >
> > > *************** **************
> > > Microsoft JET Database Engine error '80004005'
> > >
> > > 'O:\DATA\DSR\DS R_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
> > > *************** **************[/color]
> >
> > 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[/color][/color]

[bob the yob]

Re: 80004005 . . . .is not a valid path

Dont databases on iis have to have the vitual directory location?
eh I dont know if you figure it out let us know.

"Rodger" <rodgerdjr@hotm ail.com> wrote in message
news:17e4c2b6.0 405200558.66ffd 139@posting.goo gle.com...[color=blue]
> Hi all,
>
> I am getting the following error.
>
> *************** **************
> Microsoft JET Database Engine error '80004005'
>
> 'O:\DATA\DSR\DS R_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[/color]

[Rodger]

Re: 80004005 . . . .is not a valid path

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=VBScri pt %>


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

dbPath = "O:\DATA\DAR\ds r data.mdb"
Set Conn = Server.CreateOb ject("ADODB.Con nection")

conn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=O\DATA\D SR\DSR DATA.mdb" ';User Id=admin;Passwo rd="

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

'set conn = server.CreateOb ject("ADODB.Con nection")
'conn.Connectio nString = "DSN=DSR"
'conn.Open

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

mySQL = "SELECT * FROM [COST CENTERS] ORDER BY CST_DEPARTMENT"
set rs2 = conn.Execute(my SQL)


%>


Thanks,

Rodger

"Aaron Bertrand - MVP" <aaron@TRASHasp faq.com> wrote in message news:<OVPP9SpPE HA.2128@TK2MSFT NGP11.phx.gbl>. ..[color=blue]
> 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" <rodgerdjr@hotm ail.com> wrote in message
> news:17e4c2b6.0 405200959.14e30 704@posting.goo gle.com...[color=green]
> > 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]" <reb01501@NOyah oo.SPAMcom> wrote in message[/color]
> news:<egZAnOnPE HA.3460@tk2msft ngp13.phx.gbl>. ..[color=green][color=darkred]
> > > Rodger wrote:
> > > > Hi all,
> > > >
> > > > I am getting the following error.
> > > >
> > > > *************** **************
> > > > Microsoft JET Database Engine error '80004005'
> > > >
> > > > 'O:\DATA\DSR\DS R_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[/color][/color][/color]

[Bob Barrows [MVP]]

Re: 80004005 . . . .is not a valid path

Rodger wrote:[color=blue]
> Aaron,
>
> I am logged on as WEBSRV3 and yes I can see the O drive.[/color]

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"

[Rodger]

Re: 80004005 . . . .is not a valid path

I am not sure if I know what you mean?

"bob the yob" <bob@hotmail.co m> wrote in message
news:ePnc8EtPEH A.1644@TK2MSFTN GP09.phx.gbl...[color=blue]
> Dont databases on iis have to have the vitual directory location?
> eh I dont know if you figure it out let us know.
>
> "Rodger" <rodgerdjr@hotm ail.com> wrote in message
> news:17e4c2b6.0 405200558.66ffd 139@posting.goo gle.com...[color=green]
> > Hi all,
> >
> > I am getting the following error.
> >
> > *************** **************
> > Microsoft JET Database Engine error '80004005'
> >
> > 'O:\DATA\DSR\DS R_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[/color]
>
>[/color]

[Rodger]

Re: 80004005 . . . .is not a valid path

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]" <reb01501@NOyah oo.SPAMcom> wrote in message
news:uJR5g5yPEH A.3016@TK2MSFTN GP10.phx.gbl...[color=blue]
> Rodger wrote:[color=green]
> > Aaron,
> >
> > I am logged on as WEBSRV3 and yes I can see the O drive.[/color]
>
> 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[/color]
a[color=blue]
> 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"
>
>[/color]

[Aaron Bertrand - MVP]

Re: 80004005 . . . .is not a valid path

> I ran FileMon http://www.sysinternals.com/ (free software that shows the[color=blue]
> 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?[/color]

No.
[color=blue]
> I did talk to my network guy and he
> told me about what you said, and that it is set right.[/color]

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

[bob the yob]

here it is

http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_20667330.html

[Rodger]

Re: 80004005 . . . .is not a valid path

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" <aaron@TRASHasp faq.com> wrote in message
news:OPyvgJ0PEH A.2236@TK2MSFTN GP10.phx.gbl...[color=blue][color=green]
> > 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?[/color]
>
> No.
>[color=green]
> > I did talk to my network guy and he
> > told me about what you said, and that it is set right.[/color]
>
> If it was "set right" you wouldn't be having errors, no?
>
>[/color]