Re: MSSQL Problems

Take a look at the documentation at http://www.php.net/manual/en/function.mssql-close.php whhere it says "mssql_close() will not close persistent links generated by mssql_pconnect()". connections created by mssql_pconnect() will only be closed when the PHP process terminates. - Frank > 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 (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >