Re: File based database (dBASE III+)

• Previous message: dl: "Re: Runtime COMException when adding directory objects"
• In reply to: Paul Clement: "Re: File based database (dBASE III+)"
• Next in thread: Paul Clement: "Re: File based database (dBASE III+)"
• Reply: Paul Clement: "Re: File based database (dBASE III+)"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Thu, 9 Jun 2005 16:45:06 -0700

Hi Paul,

I looked that information over but I just can't get it to work.

Here is my setup.

Machine #1
    Windows XP Pro SP2
    VS.NET 2003
    ASP.NET application running in IIS 5.1
    Application using Microsoft Jet 4.0 OLEDB Provider
    Drive mapped to Machine #2 share as T:

    I followed the direction in the following article from
http://www.codeproject.com/aspnet/Sec_Run_ASPNET_WP.asp to setup a user
account on this machine. I used
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT01.asp
to setup the user permissions in the various folders.

Machine #2
    Windows 2003 Small Business Server
    Active Directory running
    Data for the ASP.NET app is on this machine's F: in a shared folder.
These are dBASE III+ files.
    I created a user account on this machine with the same name and password
as the user on Machine #1 and granted the account "Full Control" on the
shared folder.

Now I get the following error when I start the application: ASP.NET is not
authorized to access the requested resource. Consider granting access rights
to the resource to the ASP.NET request identity. ASP.NET has a base process
identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6)
that is used if the application is not impersonating. If the application is
impersonating via <identity impersonate="true"/>, the identity will be the
anonymous user (typically IUSR_MACHINENAME) or the authenticated request
user.

I checked the ASP.NET and my new account. Both have "Full Control" on this
folder.

I've worked with this problem for days and I just don't know if it can be
resolved. I have several clients that want this app. but if I can't get it
working .......

Thanks

"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:rpnga15bojfsmdouuj0p6gf55erdpl3a77@4ax.com...
> On Wed, 8 Jun 2005 10:57:06 -0700, "Dave F." <dflowers@gmail.com> wrote:
>
> ¤ I hope someone can help. I'm trying to get an asp.net application to run
> on
> ¤ a 2000 or 2003 server and access the data on a remote server. The
> database
> ¤ is dbase III+. I can access the data as long as it is on C drive but
> remote
> ¤ can't get it to access the folder over the network.
> ¤
> ¤ I've tried to use impersonation and setup the application pool for this
> ¤ purpose on the 2003 server. I even ran the user as a service. I continue
> to
> ¤ get an error page that simply states "Service Unavailable". I've spent
> hours
> ¤ trying to solve this problem but to no avail.
> ¤
> ¤ I've tried a DSN and DSN less ODBC connection to the data. I've even
> tried
> ¤ it using the Microsoft OleDb provider. Like I said, it works fine as
> long as
> ¤ everything is on the same drive.
> ¤
> ¤ Any ideas?
>
> You're encountering a delegation issue. You may want to check out the
> following article to see how
> to delegate credentials to the remote (machine) share:
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxconaspnetdelegation.asp
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)

• Previous message: dl: "Re: Runtime COMException when adding directory objects"
• In reply to: Paul Clement: "Re: File based database (dBASE III+)"
• Next in thread: Paul Clement: "Re: File based database (dBASE III+)"
• Reply: Paul Clement: "Re: File based database (dBASE III+)"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]