Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

IIS to Access DB on different server

Posted on 1998-11-02
2
Medium Priority
?
194 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 800 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
Suggested Courses

610 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