ISAPI and BDE over DBF
Posted on 2001-06-06
Hi all, here it is:
There's a NT4 SP6a, IIS4 machine, dual P3. On that, some legacy DBF tables are presented via Web interface using ISAPI DLL's written in D3 and running over BDE 4.51. The ISAPI DLL's are using CachedConnections=true currently with a pool of 50 connections.
It used to work, but lately we had to increase the pool size due to higher requests volume and increased query response time (prev pool size was around 10).
Now after some time (about 2 hours after full restart), the whole thing locks. After restarting IIS, the static pages are OK, the dynamic ones are failing and other BDE apps are failing, too, meaning that BDE got sick. The only way to restore operation is full server restart.
Any suggestions? Anyone saw that before?