FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

Can you post a small script demonstrating the problem so I can try to
replicate it here?

Cheers,

Brian

On Mon, 11 Oct 1999, Tasos Angelis wrote:

> >It sounds like PHP (or rather the apache children) are not closing the
> >connections to the database (are you using persisent connections or
> >regular ones?).  Can you verify this by logging in to the SQL Server and
> >doing an sp_who? (Note, you may need to log in before running the scripts,
> >since you may not be able to afterwards).
> >
> >Brian
> I am not using a persistent connection, and I close the connection
> at the end of the script.
> But I can see with the sp_who command that every time the 
> PHP script is running, a sleeping connection from the PHP script to
> SQL Server is left.
> Any solution to this?
> 
> Thanks in advance,
> Tasos.