Solved

IIS to Access DB on different server

Posted on 1998-11-02
2
189 Views
Last Modified: 2013-12-25
I have an IIS4 application running on NT4 server. It talks to an access database using ODBC. While the database resides on the web server, it works fine, however, when I move the database to a share on another NT server, I get a Microsoft OLE DB Provider for ODBC Drivers error '80004005'
 
   [Microsoft][ODBC Microsoft Access 97 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 am not using NT challenge/response, and the anonymous IUSR_computername exists on both servers with the same password. Using server manager on the second server, I can see that IIS is attempting to connect with no username, and so the connection is being refused. How can I force IIS to use the anonymous IUSR_machine name to connect to the second server?
TIA for any help.
0
Comment
Question by:acsmith
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
suden earned 200 total points
ID: 1856070
You will have to use Access database locally.

Go to the following link.


http://support.microsoft.com/support/kb/articles/Q180/8/15.asp

or goto Article ID: Q180815 in MS Knowledge Base

suden

0
 
LVL 1

Author Comment

by:acsmith
ID: 1856071
Thanks. Holding the database locally is not really an option. I followed the other two suggested solutions in the KB article, and neither worked :(
Guess i'll have to find another way.
Have some points for pointing me in the right direction though ;)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article was originally published on Monitis Blog, you can check it here . Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime…
Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question