Oh, checked the code, yes I am using mssql_pconnect(). I should probably use mssql_connect(). I only run this script ocassionally and once it is done, I don't need the connection to stay up. Thanks to all who responded!
-- Gerardo S. Rojas mailto: [EMAIL PROTECTED] -----Original Message----- From: Justin Patrin [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 5:34 PM To: [EMAIL PROTECTED] Subject: [PHP-WIN] Re: Connecting to MSSQL Server Gerardo Rojas wrote: > I am able to connect to my MSSQL server and do whatever i need to do. The problem > lies in that when I close the connection and the script terminates normally. I do a > 'netstat' on my machine i see that i still have a socket connection to all my > databases. Isn't the mssql_close() function supposed to close the connection? > > > > ENV: > Windows 2000 > PHP 4.3.3 > MS SQL SERVER 2000 > > -- > Gerardo S. Rojas > mailto: [EMAIL PROTECTED] Are you using mssql_connect or mssql_pconnect? If you're using pconnect, the connection is supposed to stay (that's the point of a persistent connection). -- paperCrane <Justin Patrin> -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
