Data Access mode in ADO.NET

Author	Topic
Juan J. Blanco Member Joined: 09 Apr 2003 Country: Posts: 1	Posted: 09 Apr 2003 13:55:27 Hi, I am trying to do what I believe is a very simple thing: to open a connection to a database in exclusive mode (that is, to implement pesimistic concurrency, I don´t want anybody else doing updates while I do mine). Well, in the connectionString I use in the OleDbConnection object (I am connecting to an Access D I try to set the mode to ReadWrite\|Share Deny Write, or many other variations, but I can´t seem to make it work, there are undocumented errors when I try to open the connection. Does anyone have any experience with using the access mode when opening connections in ADO.NET? Thanks in advance! Hi, I am trying to do what I believe is a very simple thing: to open a connection to a database in exclusive mode (that is, to implement pesimistic concurrency, I don´t want anybody else doing updates while I do mine). Well, in the connectionString I use in the OleDbConnection object (I am connecting to an Access D I try to set the mode to ReadWrite\|Share Deny Write, or many other variations, but I can´t seem to make it work, there are undocumented errors when I try to open the connection. Does anyone have any experience with using the access mode when opening connections in ADO.NET? Thanks in advance!
trien dao Member Joined: 10 Aug 2006 Country: USA Posts: 2	Posted: 10 Aug 2006 16:39:29 <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Hi, I am trying to do what I believe is a very simple thing: to open a connection to a database in exclusive mode (that is, to implement pesimistic concurrency, I don´t want anybody else doing updates while I do mine). Well, in the connectionString I use in the OleDbConnection object (I am connecting to an Access D I try to set the mode to ReadWrite\|Share Deny Write, or many other variations, but I can´t seem to make it work, there are undocumented errors when I try to open the connection. Does anyone have any experience with using the access mode when opening connections in ADO.NET? Thanks in advance! <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Hi, I am trying to do what I believe is a very simple thing: to open a connection to a database in exclusive mode (that is, to implement pesimistic concurrency, I don´t want anybody else doing updates while I do mine). Well, in the connectionString I use in the OleDbConnection object (I am connecting to an Access D I try to set the mode to ReadWrite\|Share Deny Write, or many other variations, but I can´t seem to make it work, there are undocumented errors when I try to open the connection. Does anyone have any experience with using the access mode when opening connections in ADO.NET? Thanks in advance! <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
trien dao Member Joined: 10 Aug 2006 Country: USA Posts: 2	Posted: 10 Aug 2006 16:42:05 I have the same problem. Do you have an answer yet? I would like to hear from you. My email is Thank you so much <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Hi, I am trying to do what I believe is a very simple thing: to open a connection to a database in exclusive mode (that is, to implement pesimistic concurrency, I don´t want anybody else doing updates while I do mine). Well, in the connectionString I use in the OleDbConnection object (I am connecting to an Access D I try to set the mode to ReadWrite\|Share Deny Write, or many other variations, but I can´t seem to make it work, there are undocumented errors when I try to open the connection. Does anyone have any experience with using the access mode when opening connections in ADO.NET? Thanks in advance! <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> I have the same problem. Do you have an answer yet? I would like to hear from you. My email is Thank you so much <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Hi, I am trying to do what I believe is a very simple thing: to open a connection to a database in exclusive mode (that is, to implement pesimistic concurrency, I don´t want anybody else doing updates while I do mine). Well, in the connectionString I use in the OleDbConnection object (I am connecting to an Access D I try to set the mode to ReadWrite\|Share Deny Write, or many other variations, but I can´t seem to make it work, there are undocumented errors when I try to open the connection. Does anyone have any experience with using the access mode when opening connections in ADO.NET? Thanks in advance! <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Main Sponsor

Visit All Zones

Latest Components

Our Sponsors

Featured Article

Beyond Graphing

When a graph is drawn, the focus is kept on the actual underlying competing figures that constitute the graph. Sometimes it is difficult to make assumptions just by looking at these graphs. When looking at a geographical map of data you immediately see exactly where things are happening. This article presents a .NET geographical mapping solution that will illustrate a fairly simple way of implementing these maps.

Featured E-Book

Design & Accessibility

Have you, as a web developer or designer ever been on sites where the site seems more of a puzzle then a tool to find the information you where looking for? Or are you looking to improve your web design skills? Then read on!

Design & Accessibility

This e-Book will teach you how to become a truly professional developer or designer. By taking usability and accessibility issues in account when designing your websites or applications you can make the difference and avoid a lot of (user) frustration.

Featured Component

3D Gal Slideshow Bndl

Get our best gallery and slideshow components in one bundle and save money! Our most popular components combined to form an amazing presentation team.

Featured Book

Inside ASP.NET is a comprehensive guide to ASP.NET development using Microsoft's .NET development framework. This book presents information on the .NET framework that is of specific interest to Internet and intranet developers, and is split into the following sections: Introducing ASP.NET, Core ASP.NET, ASP.NET and Data Access, Advanced Technologies, Advanced Web Forms, and Putting It All Together

Each chapter tackles a specific area of ASP.NET development, first by giving a detailed overview, then presenting a series of code examples and walk-throughs that illustrate various applications of ASP.NET