C#Win应用程序中的Jet Oledb连接问题 [英] Jet Oledb connection problem in C# Win Application

问题描述

我正在开发一个在服务器计算机上连续运行的Win .net应用程序.应用程序将使用Jet 4.0 OLEDB提供程序与驻留在多台客户端计算机中的access(mdb)数据库建立连接.

每个连接的数据库已被本地安装的某些其他应用程序使用.

当客户端计算机持续运行时，我的应用程序成功与所有数据库通信.

但是，如果我的一台客户端计算机出现故障(例如系统或网络)并重新启动，则尽管可以通过网络访问该应用程序，但该应用程序无法重新连接至该特定数据库.

甚至我尝试以编程方式重新启动应用程序以重新建立连接.但是，它也会失败.

应用程序会抛出

磁盘或网络错误"

或

未指定的错误"

或

无法启动您的应用程序.工作组信息文件已丢失或由另一个用户专门打开."



有人吗?

Hi,

I am developing a win .net application which runs continuously in server machine. Application will get connected with access(mdb) databases resided in several client machines using Jet 4.0 OLEDB provider.

Each connected database was already in use by some other application installed locally.

My app successfully communicates with all the databases when client machines are constantly alive.

But if one of my client machine goes down(say system or network) and rebooted, application cannot reconnect to that specific database, though it is accessible via network.

Even i tried to restart my application programmatically to re-establish the connection. But, It also fails.

Application just throws

"Disk or Network error"

or

"Unspecified Error"

or

"Cannot start your application. The workgroup information file is missing or opened exclusively by another user."



Anyone?

推荐答案

除了我也同意访问仅具有灾难数据库保证这一事实外，也许以下链接可以为您提供解决问题的方法.

http://support.microsoft.com/?scid=kb% 3Ben-us％3B300699& x = 14& y = 14 [ http://support.microsoft.com/kb/823913 [

Besides the fact that I also agree that access only has disaster database guarantee, maybe the following links can provide you with a solution to your problem.

http://support.microsoft.com/?scid=kb%3Ben-us%3B300699&x=14&y=14[^]

http://support.microsoft.com/kb/823913[^]

By the way...
- the user isn''t simply using the access db at that moment?
- is there a left over lock file (.ldb) in the same folder as the access file?


Good luck!

这篇关于C#Win应用程序中的Jet Oledb连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！