RE: DB Locking by v-kevy
v-kevy
Wed Oct 29 19:23:10 CST 2003
Hi Simon,
I'd like to know if this issue has been resolved. Is there anything I can
help on this? I'm still monitoring on it.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
--------------------
| X-Tomcat-ID: 192107448
| References: <09f401c39c96$3e6771a0$a301280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-kevy@online.microsoft.com (Kevin Yu [MSFT])
| Organization: Microsoft
| Date: Tue, 28 Oct 2003 08:21:02 GMT
| Subject: RE: DB Locking
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| Message-ID: <B7iAxxSnDHA.1804@cpmsftngxa06.phx.gbl>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Lines: 69
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:64703
| NNTP-Posting-Host: TOMCATIMPORT2 10.201.218.182
|
| Hi Simon,
|
| I could not reproduce it using the connection string you provided. By
| default, the OleDbConnection opens a .mdb database in multi-user mode if
| you didn't specify to open it exclusively. You can try to see if there is
a
| file named TypeProcessor.ldb in the same folder as TypeProcessor.mdb. If
| yes, delete it. The former user might opened the file in single-user mode
| and didn't exit properly. So the file might not be opened by multi-user.
|
| If anything is unclear, please feel free to reply to the post.
|
| Kevin Yu
| =======
| "This posting is provided "AS IS" with no warranties, and confers no
| rights."
|
| --------------------
| | Content-Class: urn:content-classes:message
| | From: "Simon Stockdale" <stockds2@hotmail.com>
| | Sender: "Simon Stockdale" <stockds2@hotmail.com>
| | Subject: DB Locking
| | Date: Mon, 27 Oct 2003 06:26:00 -0800
| | Lines: 33
| | Message-ID: <09f401c39c96$3e6771a0$a301280a@phx.gbl>
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="iso-8859-1"
| | Content-Transfer-Encoding: 7bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| | Thread-Index: AcOclj5nJq+JNdAuQcaoI/h/hIXf0Q==
| | Newsgroups: microsoft.public.dotnet.framework.adonet
| | Path: cpmsftngxa06.phx.gbl
| | Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.adonet:64619
| | NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| | X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| |
| | Hi,
| |
| | I have an application framework which consists of several
| | webservices, webpages and application all of which use a
| | couple of MS Access database. We are currently in the
| | testing phase of the project so we don't want to have to
| | upgrade to SQL Server yet.
| |
| | The problem is that when the webservices or applications
| | open the connections to the databases they open it in
| | single user mode. No matter what connection strings I use
| | they still refuse to open in multi-user mode.
| |
| | This is the connection string I'm using:
| |
| | "Provider=Microsoft.Jet.OLEDB.4.0;Password='';User
| | ID=Admin;Data
| | Source=E:\BORG\TypeProcessor\TypeProcessor.mdb;Mode=Share
| | Deny None;Jet OLEDB:System database='';Jet OLEDB:Registry
| | Path='';Jet OLEDB:Database Password='';Jet OLEDB:Engine
| | Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global
| | Partial Bulk Ops=2;Jet OLEDB:Global Bulk
| | Transactions=1;Jet OLEDB:New Database Password='';Jet
| | OLEDB:Create System Database=False;Jet OLEDB:Encrypt
| | Database=False;Jet OLEDB:Don't Copy Locale on
| | Compact=False;Jet OLEDB:Compact Without Replica
| | Repair=False;Jet OLEDB:SFP=False"
| |
| | Can you suggest anything?
| |
| | Thanks,
| |
| | Simon Stockdale
| |
|
|