RE: [PHP-WIN] closing an ODBC connection to mysql

nevermind... I guess it's a void function... someone had a better answer before I could type mine... :( --------------------- John Asendorf - jasendorf@lcounty.com Web Applications Developer http://www.lcounty.com - NEW FEATURES ADDED DAILY! Licking County, Ohio, USA 740-349-3631 Nullum magnum ingenium sine mixtura dementiae fuit > -----Original Message----- > From: Asendorf, John [mailto:JAsendorf@lcounty.com] > Sent: Tuesday, December 18, 2001 6:53 PM > To: ben; Php-Windows (E-mail) > Subject: RE: [PHP-WIN] closing an ODBC connection to mysql > > > I know this may not be very helpful, but is there a reason > you're not using > the native MySQL calls or adodb? > > In the meantime, have you tried: > > if ( !odbc_close($link) ) { > > die ("connection not closed"); > > } > > --------------------- > John Asendorf - jasendorf@lcounty.com > Web Applications Developer > http://www.lcounty.com - NEW FEATURES ADDED DAILY! > Licking County, Ohio, USA > 740-349-3631 > Nullum magnum ingenium sine mixtura dementiae fuit > > > > -----Original Message----- > > From: ben [mailto:bmf1@ukonline.co.uk] > > Sent: Tuesday, December 18, 2001 6:40 PM > > To: php-windows@lists.php.net > > Subject: [PHP-WIN] closing an ODBC connection to mysql > > > > > > 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 > > > > > > > > -- > > 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 >