Access Database Connection

Posted by Gerory on Stack Overflow See other posts from Stack Overflow or by Gerory
Published on 2010-03-31T06:58:08Z Indexed on 2010/03/31 7:03 UTC
Read the original article Hit count: 316

Filed under:

oledbconnection

I am using C#.net application with oledbConnection to open database in exclusive mode

what exactly process in backend when we open database in exclusive mode , it not increse size of database compare to shared mode connectivity.

Is it doing Compat or Repair when it close connection of Exclusive Mode??

As we are facing unExpected Errors at time of open connection using Exclusive mode & its come abnormally even we have dispossed all connection properly.

Please share ur view ...if it doing compact/reapai at time of closing connection is there a way to wait before opening new Connection?

Related posts about oledbconnection

ASP.NET and VB.NET OleDbConnection Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working on an ASP.NET website where I am using an asp:repeater with paging done through a VB.NET code-behind file. I'm having trouble with the database connection though. As far as I can tell, the paging is working, but I can't get the data to be certain. The database is a Microsoft Access database… >>> More
ASP.NET OleDbConnection Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working on an ASP.NET website where I am using an asp:repeater with paging done through a VB.NET code-behind file. I'm having trouble with the database connection though. As far as I can tell, the paging is working, but I can't get the data to be certain. The database is a Microsoft Access database… >>> More
Visual Studio 2005 - OleDbConnection throws "Invalid authorization specification" in Form Designer,

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a form with an OleDbConnection object on it. This form fails to load in the Form Designer with the message: One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes… >>> More
Force an OleDbConnection to Release a File Handle

as seen on Stack Overflow - Search for 'Stack Overflow'
Related Question My code doesn't release a file handle even after I call dispose to an initialized OleDbException. Is there a way to explicitly force the program to release a file handle? >>> More
OleDB connection only working when debugging

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a C# application that connects to a named SQL Express instance on the local machine using OleDBConnection: _connection = new OleDbConnection(_strConn); _connection.Open(); _strConn is something like this: "Provider=sqloledb;Data Source=.\NAMEDINSTANCE;Initial Catalog=dbname;User Id=sa;Password=password;" If… >>> More

Developer IT