80004005 . . . .is not a valid path

[Aaron Bertrand - MVP]

Re: here it is

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" <bob@hotmail.co m> wrote in message
news:e4IbJT0PEH A.624@TK2MSFTNG P11.phx.gbl...[color=blue]
> http://www.experts-exchange.com/Web/..._20667330.html
>
>[/color]

[Rodger]

Re: here it is

I have already check the setting for the temp directories and that was not
the issue, but thatnks . . . .

"bob the yob" <bob@hotmail.co m> wrote in message
news:e4IbJT0PEH A.624@TK2MSFTNG P11.phx.gbl...[color=blue]
> http://www.experts-exchange.com/Web/..._20667330.html
>
>[/color]

[Bob Barrows [MVP]]

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

Rodger wrote:[color=blue]
> 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?[/color]

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

What is "set right"?
[color=blue]
> Plus WEBSRV2 is setup the exact same way.[/color]

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"

[Rodger]

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

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]" <reb01501@NOyah oo.SPAMcom> wrote in message
news:eP2sii0PEH A.252@TK2MSFTNG P10.phx.gbl...[color=blue]
> Rodger wrote:[color=green]
> > 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?[/color]
>
> Sorry, 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]
>
> What is "set right"?
>[color=green]
> > Plus WEBSRV2 is setup the exact same way.[/color]
>
> 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[/color]
of[color=blue]
> the computer, that is), unless impersonation is specified in the IIS[/color]
Manager[color=blue]
> 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"
>
>[/color]

[Aaron Bertrand - MVP]

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

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" <rodgerdjr@hotm ail.com> wrote in message
news:#5wwpp0PEH A.1340@TK2MSFTN GP12.phx.gbl...[color=blue]
> Set Right meaning we did a compare of WEBSRV2 (which works) and WEBSRV3[/color]
both[color=blue]
> the same and in the same groups. I did read the TID from Novell and we[/color]
have[color=blue]
> 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[/color]