Solved

IIS to Access DB on different server

Posted on 1998-11-02
2
188 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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

734 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