Subject Re: Urgent help needed: application locks with > 1 user
Author ione1608
Hi,

I'm using PowerBuilder as the front-end. An connecting throug ODBC.
Could you explain what this object does.


--- In firebird-support@yahoogroups.com, Tiberiu Horvath
<tiberiu_horvath@...> wrote:
>
> If you use Delphi, use this TIBTransaction:
>
> object trans: TIBTransaction
> DefaultDatabase = database
> Params.Strings = (
> 'read_committed'
> 'rec_version'
> 'nowait')
> AutoStopAction = saNone
> end
>
>
>
>
> ----- Original Message -----
> From: "ione1608" <aiwa1608@...>
> To: <firebird-support@yahoogroups.com>
> Sent: Monday, October 23, 2006 10:05 AM
> Subject: [firebird-support] Urgent help needed:
> application locks with > 1
> user
>
>
> >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
> >
> > (Yahoo! ID required)
> >
> mailto:firebird-support-fullfeatured@yahoogroups.com
> >
> >
> >
> >
> >
>
> -------------------------------------------------------------------
-------------
> I am using the free version of SPAMfighter for private
> users.
> It has removed 643 spam emails to date.
> Paying users do not have this message in their emails.
> Try SPAMfighter for free now!
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>