Subject Re: [firebird-support] Re: Urgent help needed: application locks with > 1 user
Author Helen Borrie
At 04:40 AM 24/10/2006, you wrote:
>Can you please point me to the place to download this?
>Is this a beta-driver? From

Yes, it seems to be in a perpetual beta state. Try to get more
information from the firebird-odbc-devel list.

>I set the AUTOCOMMIT property of the transaction to TRUE and it
>works. When the second user wants to open the same record the first
>user already opened, I give a message that the record is in use and
>disable the save-functionality. I administer who locks a record in a
>separate table. This solution works, but how do you pro's consider
>this? A dirty solution???

Impossibly dirty. Firebird can't work this way. You have a serious
need to find out why your connections are blocking one another and fix it.

><jorge.brugger@...> wrote:
> >
> > Be sure to use last ODBC build (2.0.142). Some older builds have a
>serious > bug that produces behavior you're describing.

Take note. Get the latest driver from the praktik site and check
whether it solves your problem.