closing an ODBC connection to mysql

From: Date: Tue, 18 Dec 2001 23:40:28 +0000
Subject: closing an ODBC connection to mysql
Groups: php.windows 
Request: Send a blank email to php-windows+get-10998@lists.php.net to get a copy of this message
Hello I've installed mysql and php on W2K with IIS5.0 and I'm having some trouble closing my connection, which is established via odbc. I have been using the following php code to connect: $link = odbc_connect("forum", "ben", "dulwich") or die("Could not connect"); print "Connected successfully"; This connects successfully. I then execute my query, which returns a result. All is fine so far. Unfortunately, when I come to close the connection, I have a problem: mysql_free_result ($result); print "Connection about to be closed"; // Closing connection odbc_close($link) or die ("connection not closed"); It always prints "connection not closed". Is this because the connection is not closing, or simply that the "or die" option is not applicable for the statement "odbc_close()"? I've read the manual and been through tutorials etc but haven't found any conclusive answers on this, and I'd be gratefull for any help! Thanks very much in advance. Ben

« previous php.windows (#10998) next »