I'm using Phakt (latest version, 2.1.0 or something. Whatever came out in the last few weeks. Anyway I just checked my sql server and I have a TON of old connections that are still hanging around.

It's automagicly putting $ORDERSTOPROCESS->Close(); at the end of each page for each record set and that looks like it would close it, but it's not. There's also the feature "safe" when creating record sets but I don't usually go aroudn messing with stuff I don't know what it's going to do. This may fix it, but I wanted to ask first.

Any ideas? I was rather shocked when i saw a few dozen sleeping process on the server.

Thanks!