Re: Open Connection fails with an "Unspecified Error"

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
.

Relevant Pages

  • Project 2000. Text Column
    ... Saved and closed project. ... Saved project as .mdb file and opened it in access. ... table is showing both the original (missing) text and the newly typed text. ...
    (microsoft.public.project)
  • Re: Open Connection fails with an "Unspecified Error"
    ... The example program below is only opening an closing a "devices.mdb" ... I'm probably missing something, but a MDB file is just a file. ...
    (microsoft.public.data.ado)
  • Re: Access File Password
    ... My connection string was missing the 'Jet OLEDB:Database ' before Password. ... >>I copied the MDB file from another system, and I can open it in Access. ...
    (borland.public.delphi.database.ado)
  • Access File Password
    ... OLE DB Provider. ... I successfully open MDB files which do not have a password, ... The workgroup information file is missing ... I copied the MDB file from another system, and I can open it in Access. ...
    (borland.public.delphi.database.ado)
  • Re: Performance problem
    ... I was doing an unnecessary SQLAllocHandle and SQLFree inside a tight loop which when removed got things going again. ... It's certainly might, the one big advantage of using a mdb file is that jet 4.0 ships with windows, and windows vista right out of the box. ... The beauty of this approach would be that you would be able to run your code on Windows XP, or vista without installing additional software libraries (you'll likely have to include a ado reference in the project that you create, but other than that you would not be beholden to using MS access for your application. ...
    (microsoft.public.access.gettingstarted)
Loading