Web Development

Ask something
Discussion Locked

ASP gets data from Access DB across LAN

0 helpful
5 replies

by curtisinterruptus 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am struggling with what appears to be a simple issue. I have a straight Windows 2000 network with 2 servers; one using Active Directory and another server running an ASP application. The ASP application is attempting to access data on the AD server via a mapped drive setup in DSN, but gets the following error:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------
Technical Information (for support personnel)

Error Type:
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.
/innovetadev2/PandVReports/index.asp, line 16

Browser Type:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; AT&T CSM6.0; T312461)

The ASP line of code mentioned is:
Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.Open "DSN=PartsandVendor"

What permissions/USER account needs to be set for the application to be able to access this Access DB?

Curt

5 replies

by glen_mcleod

It sounds like you need to grant Read and Write permission on that directory to the IIS Internet user.

Read, obviously, to open the file, but also Write, because you're using an Access database which creates a .ldf file upon opening the .mdb file.

Glen

by glen_mcleod

I'm a newbie when it comes to Active Directory, but your ASP app is obviously trying to open the Access database and failing. You have to find out exactly what user account the application is running under and grant it the proper permissions. In the early days of IIS that account was IUSER_YourIIScomputername, but with Active Directory it could be something else. As I said, AD is unknown territory for me as yet.

Glen

This discussion is closed to new replies.