IIS/ASP Access database problem

[alwaysAnewbie]

First.... I tried this using UNC but no luck.
Second... DSN connection requires mapped network drive. Don't know how to assure drive is available for IUSR so I gave up on that for now.

I posted this in the IIS forum but they told me this belonged here. I have read every site/FAQ/forum I can find and followed the instructions as best I could but still no connection.

I have IIS 5.0 running on serverA. The IIS user is a local user (IUSR_SERVA).

I have an Access 97 DB on serverB that I need to query using ASP . I have a local user on serverB called IUSR_SERVA. I set the permissions on serverB so that IUSR_SERVA has read and write permissions to the share and the mydb.mdb file on the share.

I created a virtual directory in IIS called DBs that points to \\serverB\application\DBdir using a domain user dbuser. I set the permissions on serverB so that dbuser has read and write permissions to the share and the mydb.mdb file on the share.

The result is I can browse the DBdir (

http://mydomain/mydir/DBs)

directory from my web browser (turned on browsing to test) but I can't open the database using ASP (

http://mydomain/mydir/query.asp).

I get the error 80004005 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.

The ASP code is:
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection&quot
MdbFilePath = Server.MapPath("DBs\mydb.mdb&quot
Conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"

I can connect to the database if it is on the web server but that is not an option here. The only thing I am doing is simple select queries(no insert/update/delete) so open connections should not be a problem. The database is also capable of multiple sessions as that is what it does today through another application.

I know it is a permissions problem but I can't figure out what is wrong.

 

[grtammi]

http://p2p.wrox.com/archive/asp_databases/2001-05/106.asp

I don't know if this will help you, but I don't think that you can connect to an Access database on a different server ...

Greg Tammi, IT Design & Consultation
Work:

http://www.atsbell.com

Home:

http://members.shaw.ca/gregandliz

 

[alwaysAnewbie]

I thought that was what a virtual directory was for.

According to several places on the web you can access them.

Here are a couple of examples:

http://aspfaq.com/show.asp?id=2168

http://support.microsoft.com/?kbid=207671

Somebody must have it working....

I just can't figure out why mine won't work.