At 06:04 PM 02-05-02 -0300, Vinicius wrote:

>I am using FIB super server V1.0
>
>With one computer reading data from the database server.
>( My server is a Windows 2000 professional - P4 1.5 Ghz 512 RAM AND a
>another server is a Linux Red Hat 7.2 K6 2 - 500 Mhz with 64 MB ram )
>
>My problem is :
>
>At 5 and 5 seconds I close and open one query that read data from one table,
>after some minutes that my program is running at this form just doing this
>query the program start to report a error with this message :
>
>"Too many concurrent executions of the same request"
>
>Why, I don't really believe what I see...

At 5-second intervals, you are doing this?
Start transaction
Run the query
Start transaction
Run the query
Start transaction
Run the query
......
Eventually, something is going to break.

You need:
Start transaction
Run the query
Commit the transaction
Start transaction
Run the query
Commit the transaction
Start transaction
Run the query
Commit the transaction
.....

More information would be useful.

Also, please post ONE question to ONE list. So far today I have counted
four instances of the same question in three lists. As all of your
questions are support questions, they belong HERE, not in IB-Architect or
firebird-devel.

Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________