Skip to Content.
Sympa Menu

freetds - ODBC MS SQL 7.0 Not closing connection

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Eric Liedtke <jesus AT musinghalfwit.org>
  • To: php-db AT lists.php.net, TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: ODBC MS SQL 7.0 Not closing connection
  • Date: Wed, 12 Dec 2001 15:32:51 -0600


I am not sure where this is going wrong so I am hoping to find an answer
on one of these 2 lists. I am using freetds/unixodbc in php to connect
to an MS SQL7 server. I was having some problems with the connection
hanging open, so I removed all me queries and trimmed my script down to
a simple db open and close, however my connection still stays open and
the odbc_close() fails. Here is the script...


<?php
putenv("ODBCINI=/usr/local/etc/odbc.ini");
putenv("ODBCINSTINI=/usr/local/etc/odbcinst.ini");
putenv("LD_LIBRARY_PATH=/usr/local/freetds/lib");
$mydbhandle = odbc_connect("TroubleDB","","") or die ("Could not
connect to the DB<BR>\n");
odbc_close($mydbhandle) or die("Could not close db connection");
?>
Any ideas on where to look? Thanks for the time

Eric Liedtke




  • ODBC MS SQL 7.0 Not closing connection, Eric Liedtke, 12/12/2001

Archive powered by MHonArc 2.6.24.

Top of Page