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 - [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
> Sent: Tuesday, December 18, 2001 6:40 PM
> To: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
