mssql_close() doesnt do anything when you use mssql_pconnect as this is a persistant 
connection. If you want to close the connection after you've finnished with it you 
should use mssql_connect() instead.
Hope this helps

-----Original Message-----
From: Tim Evans [mailto:[EMAIL PROTECTED]]
Sent: 05 December 2002 13:33
Subject: [PHP-DB] MSSQL Problems

I've written a script that works perfectly for almost ten times, and then
stops being able to connect to the MSSQL server.  I imagine this has
something to do with me not properly closing my connection, and the server
having a maximum # of connections.

I'm calling both mssql_free_result() and mssql_close() after every query.
I'm using mssql_pconnect.

I would include sample code, but it does this whether I use code ripped
right from examples and docs or I write it myself.  It doesn't seem to
matter what database, or the type or amount of information I'm requesting.

Thanks for any help I get on this problem, it's driving me nuts.

PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to