Re: Open Connection fails with an "Unspecified Error"
- From: harald.deischinger@xxxxxxxxxx
- Date: Wed, 16 Jan 2008 23:49:29 -0800 (PST)
On 16 Jan., 19:05, "Ralph" <nt_consultin...@xxxxxxxxx> wrote:
<harald.deischin...@xxxxxxxxxx> wrote in message
news:5570639e-cada-4693-bea2-80ffedaf3373@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> When opening a mdb database from two processes, each using two threads
on many systems I catch sometimes an "unexpected error".
The error only shows up when using at least two processes with two
threads each, or using three processes one thread each. Strangely the
problem does not show on some systems. Most times the error shows up
just after one second of running the test application in two
processes, but sometimes several minutes of waiting are needed.
The example program below is only opening an closing a "devices.mdb"
database continuously.
<snipped>
I'm probably missing something, but a MDB file is just a file. With multiple
processes in a tight loop, IMHO, the only thing that would be "unexpected"
would be if there were NO errors. It is probably ADO Connection pooling that
keeps it error-free for those times it lasted "several minutes". <g>
-ralph
The MDB is a simple Access MDB file.
Maybe I should also add that the code above is only to provoke the
error. In the real application it happens at most once a day of
continuous usage.
Harald
.
- Follow-Ups:
- References:
- Open Connection fails with an "Unspecified Error"
- From: harald . deischinger
- Re: Open Connection fails with an "Unspecified Error"
- From: Ralph
- Open Connection fails with an "Unspecified Error"
- Prev by Date: Re: Open Connection fails with an "Unspecified Error"
- Next by Date: Re: Open Connection fails with an "Unspecified Error"
- Previous by thread: Re: Open Connection fails with an "Unspecified Error"
- Next by thread: Re: Open Connection fails with an "Unspecified Error"
- Index(es):
Relevant Pages
|
|
