Re: Emergency! Too Busy A Connection!

Tech-Archive recommends: Speed Up your PC by fixing your registry

It's too bad you didn't do more research before you committed to using a
home/small office database to implement a serious application. You're trying
to deliver coal with a bicycle. Jet was never designed to be used in an ASP
environment. The problems you face now during testing will pale in
comparison to the problems you (and your customers) will face when you go
into production. It's true that a JET database file can be accessed by many
users--a number of users far less than SQL Server or any serious DBMS.
However, every aspect of the application needs to be written to take JET's
limitations into account. You can't (for example) fetch all of the rows of
the table(s) or expect the engine to perform complex JOIN operations and
still support multiple users. Actually, JET was designed to support multiple
users by permitting each user to have their own JET engine running on the
client system. In an ASP application, you have one JET database that's asked
to perform operations on its own. Because (by default) JET delays writing to
the database file until it's idle, when the load picks up it's never idle.
If you disable this feature, JET blocks all operations while writing thus
slowing down or stopping other access.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Ehsan" <Ehsan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2FC987C2-3B0A-4BB4-9C76-199059A8344D@xxxxxxxxxxxxxxxx
> Thank you guys.
>
> I can't redesign my app because it is nearly finished and everything is
> now
> designed to work with Access.
> What I really wanted was a way to understand when the connection is
> becoming
> available again. It is true that multiple threads can't load from an mdb
> database
> at the same time, but I was thinking about putting all my requests in a
> queue and
> considering them one by one. Is there anyway to see if the connection is
> availabe?
> I tried the connection's StateChanged event, but it doesn't tell me if I
> can
> continue my operation. (By the way, it seems that the connection's State
> property currently can only report whether the connection is open or
> closed,
> not anything else, is that right?)
> Thank you again.
>


.

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)
  • Re: Closing Jet Database seems unreliable
    ... Could it be that JET has not finished writing the cache to the database? ... and the connection ... I want to do this so that my app can backup or restore the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: test connection failed
    ... .udl contains connection string and path to database (for Microsoft Jet ... Check also that you have Jet provider installed or install Jet SP from ...
    (borland.public.delphi.database.ado)
  • Re: ADO Connection Timeout
    ... connection to my Access database becomes unavailable. ... Jet, and it's free. ...
    (microsoft.public.data.ado)
  • Re: Database Connectivity
    ... Never was Jet mentioned anywhere at anytime. ... >> Microsoft Access Database Solutions, with not a single mention of Jet. ... front end, and the underlying database engine, JET. ... like SQL Server, Sybase, MySQL, etc. ...
    (comp.lang.python)