DB Locking

  • Thread starter Thread starter Simon Stockdale
  • Start date Start date
S

Simon Stockdale

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
 
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" <[email protected]>
| Sender: "Simon Stockdale" <[email protected]>
| Subject: DB Locking
| Date: Mon, 27 Oct 2003 06:26:00 -0800
| Lines: 33
| Message-ID: <[email protected]>
| 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
|
 
¤ 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?

Could you identify the error messages you are getting?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
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: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: (e-mail address removed) (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: <[email protected]>
| 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" <[email protected]>
| | Sender: "Simon Stockdale" <[email protected]>
| | Subject: DB Locking
| | Date: Mon, 27 Oct 2003 06:26:00 -0800
| | Lines: 33
| | Message-ID: <[email protected]>
| | 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
| |
|
|
 
Back
Top