🚀 go-pugleaf

My application uses IB 1.5, with borland web server and three agents.
The program is at the moment running on a stand alone PC and MSSQL
database.

I am getting a few problems  with my application such as:
1)after a few connections to the server I get messages like no data
record available or network error, cannot connect, try later etc. This
problem is easily solved by rebooting my server which i don't want to do
that often.

2)suppose a server click involves writing to 3 different tables in  a
database. But the connection gets broken at times after writing to just
two tables. This totally messes up my application. The problem is that
at times it takes longer to write into the same table. So i thought
maybe one of the tables get locked during the process because of which
it can't complete editing a rowset. So i wrote all my sql queries with
(NO LOCK). Could this be the solution?

3)I make all queries active property to false before moving from one
form to the next. Still I need to reboot my computer quite often.
(Database active property is true for all forms or report).

4)I've configured my Borland web servers as  follows:
min connections 25
max connections 100
connection time out 60
allow keep alive connections
Max request per connections 20

I expect about 10 client computers to access my computer at a time. Do i
need to change this configuration?

I would be grateful if i could get any suggestions for any of my
problems above.

PS I'm also trying to transfer my application to a NT workstation.


Thanks a lot in advance

Luna Rajbhandari