Connect to MS Access DB on different server

[Roby2222]

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,
Roby2222

 

[[MSFT]]

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

 

[Roby2222]

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

 

[Paul Clement]

¤ 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?
¤

That would be my guess. Can you use an UNC path instead?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Roby2222]

I don't think you can use UNC with DSNs, but I'll give it a try with OleDB.

Thanks,
Roby2222

 

[Paul Clement]

¤ I don't think you can use UNC with DSNs, but I'll give it a try with OleDB.
¤

If you're using a DSN that means you're using the MS Access ODBC driver. I would highly recommend
you use a DSN-less connection with the Jet OLEDB driver instead.

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[[MSFT]]

Hello,

Since it is a user group, I think you may use Roles instead of Users. For
example:

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


Luke