Re: Error when connected to Access MDB

sterling_at_fiac.net
Date: 05/04/04 

Date: Tue, 4 May 2004 03:16:49 GMT

If you use Microsofts ODBC.NET Data Provider instead of OleDB.NET, it will
let you have more than one connection to the database, it creates a
connection pool. When using OleDb to open a database it locks the database,
and it has a time out of so many seconds before it releases the connection
something like 10 secs after its closed. When your using the ExecuteReader
no matter what the provider is, you can't use the same OleDbConnection to
execute another instance of ExecuteReader with the same OleDbConnection. If
you open Component Services and find the connection that has been created
for your application you will see that when your application runs it will
create a service for the application when it executes. You can manually
release the connection, so you don't have to wait for OleDB to release it
while your testing your code.
Hope this helps.
Sterling

Relevant Pages

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • SQL Server 2005 Express connection error?
    ... getting an "Unable to find the requested .Net Framework Data Provider. ... //Obtain the database connection string ... //Obtain a database specific connection object ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... much rather write stored procedures and use server side cursors. ... local database, it is vital that I get the information to a central server. ... Once the connection is restored, ...
    (microsoft.public.data.ado)