ODBC Connection to mapped drive.

[morpheus000]

I am trying to setup an ODBC Source on a webserver (IIS 4, NT 4) to an Access 97 database which resides on a separate file server (from the web server). This is simlar to the post made by ChuckG in a previous thread on this forum. I believe that there is a slight variation in scenarios
as I am not trying to connect to a database in another domain on our netowrk. The fileserver with the database is in the same domain as the webserver. So I am not sure if I am having the same problem as Chuck or not.

Here is what I am doing to setup the DSN:

I select a System DSN, Select the Access 97 Driver and then using the ODBC COnfiguration window 'browse' my way to the network location of the Access database. I do the same thing for the system database (workgroup) file.

When I try to connect to the source through an ASP page, I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

I have verified the username and password in the connection properties and I know that the database is NOT opened exclusively by someone else. The account in the workgroup that I am authenticating against the database has Admin level rights.

Any thoughts or suggestions. What is the best way to setup an ODBC source to a DB stored on a remote file server?

Thanks in advance!
b

 

[garyds]

Try connecting to the access database when logged on to the IIS machine as the user IIS uses to log on to the domain (you can check this in services, startup for the IIS service)

Although your user account can see the directory on the other machine, the IIS user account cannot (could possibly be IUSR_Anonymous or administrator it's a long time since I installed IIS and depends on config).

Make sure that this user has access to the file you need.

Cheers

Gary