469,328 Members | 1,251 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,328 developers. It's quick & easy.

How to acess mdb from a remote machine in ASP

Hi,
I have developed an application in asp with backend as ms-access database.
The mdb file is on a one machine and my IIS is running on a different
machine. The code which I tried is as follows
<%
set con = server.CreateObject("adodb.connection")

I tried both dsn and dsn-less
DSN-LESS
con.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq=\\<machine
name>\remote\remotedb.mdb;"

DSN
con.Open("DSN=remote;")

set rs = server.CreateObject("adodb.recordset")
Set rs = Con.Execute("Select * from Employee")
response.write("Sucess")
%>

The changes what I did in IIS
In directory security of this application I changed the Authentication
method to IUSR_MACINENAME with Allow IIS to control password. But when I
view the page its throwing error, which is given below

Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [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.

Please let me know how to resolve this problem.
I looked at KB article no. 189408, and as described, took off the password
control from IIS.
but still it is not solving my problem. And I also have the reqd.
permissions on the folder that contains the mdb file.
Pl note that there is no error when I run the application from the same
machine where IIS is running.
The problem occurs only if I access the application from a client machine.
Please advice accordingly.
What should be the code in ASP and what should be IIS settings.

Regards,
RR
Jul 19 '05 #1
1 1610
Rajesh R. wrote:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[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.

Your answer will be found in this article:
http://www.aspfaq.com/show.asp?id=2009
Read carefully. :-)
HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Rohith | last post: by
1 post views Thread by Rajesh R. | last post: by
7 posts views Thread by | last post: by
3 posts views Thread by Yves Gagnon | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Purva khokhar | last post: by
reply views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.