Are you using odbc_free_result before odbc_close? The documentation doesn't do it justice. For SQL server it seems to be the only way to release the connection.
<>< Ryan -----Original Message----- From: Andrew Rall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 3:40 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] php_close( ) not working on PHP+FreeTDS+UnixODBC+MSSQL7 I'm having a slight problem closing ODBC connections to my MSSQL7 server. My configuration is as follows Web server ----------------------- Redhat Linux 7.3 Apache-1.3.23-11 PHP-4.1.2-7 FreeTDS-0.53-1 unixODBC-2.2.0-5 SQL Server ----------------------- NT4.0+SP6a MS-SQL7.0+SP3 odbc_close($conid) doesn't give any errors, but the connection stays open on the SQL server. After refreshing the page a couple of times, I eventually run out of licences. When using iSQL under Linux I can open and close connections successfully. Only through PHP it doesn't work. Any ideas? Regards Andrew -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
