I am trying to connect to a Microsoft Access database, located on a different
server. I am using ASP.NET and the code I am using works when run from my
local IIS, but it does not work when I deploy the project to the web server.
The database is not on the web server or my local machine. I am currently
using a DSN, which is setup on both machines through a mapped drive.

I disabled Anonymous Authentication on the IIS directory and enabled
"Integrated Windows Authentication". In my web.config settings, I set the
following:

<authentication mode="Windows"/>
<identity impersonate="true"/>

<authorization>
<allow users="IS-Users"/>
<deny users="?"/>
</authorization>

Here is the first part of the error I receive:

Data Retrieval Error. System.Data.Odbc.OdbcException: ERROR [HY024]
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' 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.

The security of the web page works correctly, but I don't think it's
delegating the credentials properly. I thought it would by setting the
Impersonate property to true.

I have the option of using OleDB if that is a possible solution. Any ideas
would be appreciated.

Thanks,

Hello Roby,

Is the account "IS-Users" a local user or a domain user? If you logon as
this user and access the web app, it will use this account to permission to
open the access database file. If it is local account, we need to create a
same account with on the remote server; if it is a domain account, it
should be enough pemission on the remote server. For more info about
ASP.NET impersonate, you may refer to this article:

INFO: Implementing Impersonation in an ASP.NET Application
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q306158

Luke

Thanks for the reply. The "IS-Users" account is a domain group, and it has
permissions to the folder where the Access database resides. Could it be
this user does not have visibility to the mapped drive on the web server?

Thanks,
Roby2222

[quoted text, click to view]