--- In firebird-support@yahoogroups.com, "Glebas" <glebasp@...> wrote:

>
> Stan,
>
> > The error always happens in the same place in the code:
>
> Which function returns this?

one of my stored procedures.

>
> > I am using the default transaction settings (snapshot,
> > write I think).
>
> If this happens on the heavy load only, you should be very
> careful about how do you manage transactions. What TPB parameters
> do you supply for 'isc_start_transaction'?

NULL, but I also tried:
static char isc_tpb[5] = {isc_tpb_version3,
isc_tpb_write,
isc_tpb_read_committed,
isc_tpb_wait,
isc_tpb_no_rec_version};

with the same result.

>
> > Each client is inserting 1 record into 8 tables followed
> > by an update on 2 of the records that were just inserted.
> > This operation is done in a single transaction. I have tried
> > separate transactions, but had the same result.
>
> Keep it single transaction.
>
> > At the same time other clients are selecting from these tables.
>
> If they are reading only - do it within read-only transcation.
> What TPB parameters do you supply for 'isc_start_transaction' in
> this case?
>

same.

> Make sure that you commit(rollback) transactions as soon as possible.

I am doing this.

>
> --
>
> I also have a problem using Firebird with CGI on Windows XP SP2:
>
> If my C++ CGI application works with a local embedded firebird
> database residing in the same cgi-bin directory, then no problem -
> I can use my browser to work with a database.
>
> However if my CGI application tries to connect to Firebird server
> running on the same machine - then there is a problem "SQL error:
> unavailable database"
>
> How did you manage to setup CGI with Firebird?

provide a full connection string: <host>:<db>
try: localhost:database.fdb

>
> Regards,
> Glebas
>