Hi,
> -----Original Message-----
> From: Richard Morton [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 17, 2002 4:14 AM
> To: MySQL List; Mysql Bugs; MyODBC
> Subject: FWD: RE: ECS Error with 4.0.07 opening DB (still)
> again -EMEA2490
>
>
> please see below
>
>
> ---------- Forwarded Message ----------
>
> FROM: "euro.support" <[EMAIL PROTECTED]>
> TO: "Richard Morton" <[EMAIL PROTECTED]>
> DATE: Fri, 17 May 2002 10:26:06 +0200
>
> RE: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490
>
>
> Hi Richard,
>
> I have received an answer from our dev team, please see below:
>
> ------------------------------
> MySQL does not accept
> SQLSetConnectAttr function for setting the
> SQL_ATTR_CONNECTION_TIMEOUT
> which is added recently to the same value as the query timeout.
>
> Unfortunately although it is legal ODBC 3.0 parameter MySql
> crashes instead of reporting error if it does not support it.
> This should be considered MySQL bug.
MySQL/MyODBC does accept connection timeout. Here is the code
snippet from driver:
case SQL_ATTR_CONNECTION_TIMEOUT:
DBUG_RETURN(mysql_options(&dbc->mysql, MYSQL_OPT_CONNECT_TIMEOUT,
(const char *)((SQLUINTEGER)ValuePtr)));
break;
So, driver does set correctly. Make a note that, the value '0' means
default in ODBC, and that means no timedout.
How does MySQL crash for this parameter ?
Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ California, USA
<___/ www.mysql.com
>
> Code is changed in PU 8 not to call this function if timeout
> is set to 0.
> I will post here just a FDbase.fdl which can be used even on
> PU007 Release.
> But customer still needs to change its script to set query
> timeout to 0.
> How-To-Repeat:
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
