Re: COM, ADO, PHP4 and SQL Server

I dont know why ADO is unable to close the connection, but I think ADO is trying to do connection poling by having persistant connections. Try to disable connection poling in the ODBC Manager. ADO is just another abstraction on ODBC. You would actually get higher performence by using PHP's native driver for MSSQL ! - Frank >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 >> > > > >-- >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 > > >