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

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

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

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******@NOyah oo.SPAMcom> wrote in message
news:eg******** ******@tk2msftn gp13.phx.gbl...

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

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

[Bob Barrows [MVP]]

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******@NOyah oo.SPAMcom> wrote in message
news:eg******** ******@tk2msftn gp13.phx.gbl...

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

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

[Aaron Bertrand - MVP]

> 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! ;-)

[Rodger]

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******@NOyah oo.SPAMcom> wrote in message news:<eg******* *******@tk2msft ngp13.phx.gbl>. ..

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

[Aaron Bertrand - MVP]

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*******@hotm ail.com> wrote in message
news:17******** *************** ***@posting.goo gle.com...

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******@NOyah oo.SPAMcom> wrote in message

news:<eg******* *******@tk2msft ngp13.phx.gbl>. ..

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

[bob the yob]

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*******@hotm ail.com> wrote in message
news:17******** *************** ***@posting.goo gle.com...

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

[Rodger]

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" <aa***@TRASHasp faq.com> wrote in message news:<OV******* *******@TK2MSFT NGP11.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*******@hotm ail.com> wrote in message
news:17******** *************** ***@posting.goo gle.com...

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******@NOyah oo.SPAMcom> wrote in message

news:<eg******* *******@tk2msft ngp13.phx.gbl>. ..

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

[Bob Barrows [MVP]]

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"