Solved

IIS to Access DB on different server

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
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…

762 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now