RE: [Firebird-net-provider] sweeping

[Alan M. <al...@me...>]

> I've just been trying to write a scheduled program to sweep the=20
> database - am I right in thinking there must be NO active=20
> connections in the pool for sweeping to be successful??
> =20
> Isn't this a bit of a drawback???
> =20
> Thanks,
> =20
> John

you don't need to manually run sweep - you set an interval at the =
server. but if you really need sweep then there is something wrong with =
your transaction control.
Alan