Web场上的MS Access [英] MS Access on a web farm

问题描述

有没有办法在Web场（不在域上）上设置连接到第三台服务器（在域上）的MS Access文件？


硬件/操作系统：

Windows Server 2003
Web Farm（两个网络服务器，网络负载均衡，或NLB）

ASP。 NET v1.1

Microsoft Access 2003

我们正在寻求建立一个NLB webfarm。其中一个网络应用程序使用MS Access数据库。

给定NLB（2个方框），MS Access数据库不能驻留在任何一个上（删除单点故障方案） ）。

NLB不属于域名。

我们已将MS Access文件放在第3台服务器上（属于域名）。 br />
我们可以看到第三台服务器上的文件（例如提供图像和其他页面。在Web.Config中，我们把这个连接字符串：

\\ Server3 \ MSAccess\DatabaseFile.mdb


共享文件夹\\Server3 \ MSAccess |以便为每个人完全控制;包括访客（是的，安全漏洞......）


我们不断收到以下错误，我们还没有成功解决：


Microsoft Jet数据库引擎无法打开文件''\\Server3 \ MSAccess \DatabaseFile.mdb''。它已由其他用户专门打开，或者您需要查看数据的权限。


我确实访问了微软的网站并阅读了几篇KB文章，但没有成功; ＃253580，＃315276（NTRights Utlitity）



有没有办法装载 \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

Gary Noter

Is there any way to set up connecting to an MS Access file on a 3rd server (which is on a domain) from a Web Farm (which is not on the domain)?

Hardware/OS:
Windows Server 2003
Web Farm (two web servers which are network load balanced, or NLBs)
ASP.NET v1.1
Microsoft Access 2003

We''re seeking to set up an NLB webfarm. One of the web-apps uses a MS Access database.
Given the NLB (2 boxes), the MS Access database can''t reside on either (to remove "single point of failure" scenario).
The NLBs are not part of the domain.
We''ve put the MS Access file on a 3rd server (which is part of the domain).
We can see files on the 3rd server (such as serving up images and other pages. In the Web.Config, we put this connection string:
\\Server3\MSAccess\DatabaseFile.mdb

The folder \\Server3\MSAccess| is shared for full control for everyone; guests included (yeah, security hole...)

We keep getting this following error, to which we''ve not been successful in resolving:

The Microsoft Jet database engine cannot open the file ''\\Server3\MSAccess\DatabaseFile.mdb''. It is already opened exclusively by another user, or you need permission to view its data.

I did visit Microsoft''s website and read through several KB articles, but no success; #253580, #315276 (NTRights Utlitity)


Is there any way to "mount" \\Server3\MSAccess\ shared folder as a specific lettered drive when the sever starts up (vs having to log on)?

Any insights appreciated.

Gary Noter

推荐答案

嗨Gary


我经常使用Access数据库一个Citrix农场，但不幸的是与他们在那里建立无关。我会和一些专家谈谈，他们可以提供帮助，看看可以做些什么。


Mary

Hi Gary

I''ve frequently used Access databases though a citrix farm but unfortunately had nothing to do with setting them up there. I will have a word with some experts who may be able to help and see what can be done.

Mary

我完全不熟悉访问;但是，我对数据库有一些了解。你在这里听到的是权限冲突。我不知道您是如何尝试访问Access数据库的，因为您没有发布任何代码以附带您的问题，但错误暗示您的用户没有数据库权限（而不是文件）请注意，数据库本身）。这个，或者其他人对数据库有独占锁。该文件是否被其他人使用？

I am entirely unfamiliar with Access; however, I do have a bit of knowledge with databases. What it sounds like you have here, is a permissions conflict. I don''t know how you are trying to access the Access database, because you did not post any code to accompany your question, but the error alludes to the idea that your user does not have permissions on the database (not to the file mind you, the database itself). Either that, or someone else has an exclusive lock on the database. Is the file in use by anyone else?

好建议Motoma。我假设数据库已经在多用户环境中正常工作。


在数据库中转到工具 - 选项 - 高级并检查默认打开模式是否未设置为独占。它应该设置为共享。此外，默认记录锁定应设置为编辑记录，但这不会导致错误。


Mary

Good suggestion Motoma. I assumed the database was already working correctly in a multi user environment.

In the database go to Tools - options - advanced and check that the default open mode is not set to Exclusive. It should be set to Shared. Also the Default Record Locking should be set to Edited record although this would not be causing the error.

Mary

这篇关于Web场上的MS Access的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！