Re: ADO returns Unspecified error
From: Douglas Laudenschlager [MS] (douglasl_at_online.microsoft.com)
Date: 07/20/04
- Next message: Al S: "Create Dataset"
- Previous message: William \(Bill\) Vaughn: "Re: Hi Wlliam"
- In reply to: Ken1: "Re: ADO returns Unspecified error"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Jul 2004 15:47:58 -0700
Well, it sounds like you've tried the obvious things. Again, I'm at a
disadvantage for lack of familiarity with this provider.
Some tools to try might be:
- FileMon, to confirm that ACCESS DENIED is in fact the problem on Server
B, http://www.sysinternals.com/ntw2k/source/filemon.shtml
- Windows auditing, which would show you the additional crucial piece of
info, viz. WHAT user account is trying to access the file. This has to be
turned on at the system level first, then auditing settings turned on also
on the file you're trying to open, and describing where and how is beyond
the scope of a short email.
310399 How To Audit User Access of Files, Folders, and Printers in Windows
XP
http://support.microsoft.com/?id=310399
Best regards,
-Doug
"Ken1" <Ken1@discussions.microsoft.com> wrote in message
news:8D4A8692-4931-428A-ADD7-84E1686597E4@microsoft.com...
> Doug,
> Thanks for the suggestion. Actually, when I tested objRecord.Open with a
non-existing file name, it caused an error so I think IIS is hitting the
remote file already there.
>
> Yes, I am accessing my web site anonymously and the ASP on that server
(say, comp-A) is trying to get a file from another server (say, comp-B)
connected via VPN. That comp-B is also configured with IIS to allow http
from comp-A. Both comp-A and comp-B are not using domain system (in
workgroups).
>
> What do you mean by "mirror account" or "domain account"?
>
> What I tried is to set IIS of comp-B with anonymous access with
"IUSR_comp-B" account and use its username/password in the
objRecord.Open/ojbStream.Open. Also tried to set IIS of comp-B with no
anonymous access still using "IUSR-comp-B" as the username/password in the
objRecord.Open/Stream.Open lines of ASP on comp-A. Also tried with
completely new account created on both comp-A and comp-B and gave
permissions for the folder on comp-B. All of the above gave the same
result. In the course of these testing, occasionally made some mistakes in
putting incorrect username or password, which caused "permission denied"
error for objRecord.open line, so I assume correct NTSF security checking is
functioning for that line. I am still puzzled...
>
> Ken
>
> "Douglas Laudenschlager [MS]" wrote:
>
> > I would guess that the objRecord.Open line isn't really doing anything,
> > waiting to open the connection until you actually try to do something
with
> > it...so the objStream.Open line, where your error occurs, is actually
the
> > first time the provider is trying to hit the remote file. Unfortunately
I'm
> > not familiar at all with MSDAIPP.
> >
> > Are you accessing your web site anonymously, and going after a file on
> > another computer? If so, the first thing you'll need to do is either
create
> > a mirror account on the other computer of the local IUSR account, so you
can
> > give it permissions to the file, or switch to a domain account that's
> > recognized on both computers.
> >
> > -Doug
> >
> > --
> > Douglas Laudenschlager
> > Microsoft SQL Server documentation team
> > Redmond, Washington, USA
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "Ken" <Ken@discussions.microsoft.com> wrote in message
> > news:E67BCDF6-8C8D-47D8-A94A-1D723D09E79D@microsoft.com...
> > > Thank you, Doug for your reply. I think so, too, that this is an NTFS
> > file permission issue. However, when I set username and password with
> > objRecord.Open it went through but objStream.Open objRecord... causes
> > unspecified error. When I use the same user name and password that were
ok
> > with objRecord.Open with objStream.Open (this time not pairing with
> > objRecord.Open), it causes permission error. So I am very puzzled what
kind
> > of user name/password I should use!
> > >
> > > I appreciate any help on this puzzle.
> > > Ken
> > >
> > > "Douglas Laudenschlager [MS]" wrote:
> > >
> > > > This is almost without a doubt an NTFS file permissions issue.
Assuming
> > that
> > > > you're running the ASP site anonymously, the other computer doesn't
> > > > recognize the IUSR account local to your machine. You will need to
use a
> > > > domain account, or set up a "mirror" local account on the other
server,
> > and
> > > > give appropriate file permissions on the other server to whichever
> > account
> > > > you use.
> > > >
> > > > -Doug
> > > >
> > > > --
> > > > Douglas Laudenschlager
> > > > Microsoft SQL Server documentation team
> > > > Redmond, Washington, USA
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > > "Ken" <Ken@discussions.microsoft.com> wrote in message
> > > > news:A8FD51D5-E3DC-4F83-A9F1-C5018F5DE49E@microsoft.com...
> > > > > When I tried to fetch a flat file from another server in the same
> > private
> > > > network, I got "Provider error "80004005" Unspecified error. The
ASP
> > code I
> > > > used was:
> > > > > objRecord.Open "Database.log", "URL=http://server-3/Logs"
> > > > > objStream.Open objRecord,, adOpenStreamFromRecord
> > > > >
> > > > > The objRecord.Open line went through and objStream.Open line
> > encountered
> > > > the error. Can anyone shed light on this problem? I really
appreciate
> > it.
> > > > > Ken
> > > >
> > > >
> > > >
> >
> >
> >
- Next message: Al S: "Create Dataset"
- Previous message: William \(Bill\) Vaughn: "Re: Hi Wlliam"
- In reply to: Ken1: "Re: ADO returns Unspecified error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
