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: grojas@xxxxxxxxxxxxxxxx -----Original Message----- From: Justin Patrin [mailto:papercrane@xxxxxxxxxxxxxxx] Sent: Wednesday, February 25, 2004 5:34 PM To: php-windows@xxxxxxxxxxxxx Subject: 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: grojas@xxxxxxxxxxxxxxxx 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
