Re: COM, ADO, PHP4 and SQL Server

I have tried closing the connection and recordset and 'unset' the objects, but it doesn't make any difference. Any more ideas? By the way I am using PHP 4..03pl1 on WinNT4 SP6a and SQL Server 7.0 SP2. Ta Peter "Andrian Pervazov" <apervazov@aspen-marketing.com> wrote in message news:3A1BD275.A82D9107@aspen-marketing.com... > > Peter wrote: > > > > Hi There > > > > I creating the ADO COM objects in PHP and using them to access a SQL Server > > database. This is all working fine. One thing I have noticed, however, is > > that the connections to the database never get released. If I run sp_who on > > the SQL Server database, I get a new connection everytime, which is not > > killed after my script has finished executing. This obviously causes a > > problem as every time I access a PHP page, a new connection is created and I > > end up with tons of them. > > > > Any one else had this problem or have any ideas how I might resolve it? I > > don't want to use the mssql70 extension, since I like the database > > abstraction of ADO. > > Did you try calling the close method for the recordset and the > connection objects and setting them to nothing? Does it help? > > Andrian > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >