Can you please point me to the place to download this?
Is this a beta-driver? From http://www.praktik.km.ua/?

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???

--- In firebird-support@yahoogroups.com, "Jorge Andres Brugger"
<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.
>
> Regards.
>
> 2006/10/23, ione1608 <aiwa1608@...>:
> >
> > I have the following problem:
> >
> > I made an application which uses a FireBird database. The

database

> > (SuperServer 1.5) runs on a pc. I have two clients connecting to
> > this database. Both clients use the same database user (which I
> > setup in the ODBC Administrator).
> > I thougt I was finished developing and began testing the
> > application. What happens is this:
> > Client 1 opens a window on which data is shown. When I open the

same

> > window on client 2 with another record, the window doesn't show

the

> > data. It looks like it's waiting. Even when I close the window on
> > client 1, client 2 is still 'waiting'. Only when I quit the
> > application on client 1, client 2 suddenly shows the data.
> > I'm quite a newbie with FireBird. I tried searching for the

reason,

> > but 'didn't find the solution or a post in which the same

problem is

> > discussed.
> > Is this what they call a deadlock?
> > The query I use is just a select (with noting about locks in it).
> >
> > Is this problem known?
> >
> > I hope somebody can help me out. The customer is expecting me to
> > install the application in two days on his site.....
> >
> >
> >
> >
> >
> >
> >

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> >

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>