[freetds] Timeout problem
Frediano Ziglio
freddyz77 at tin.it
Thu Sep 22 09:15:26 EDT 2005
Il giorno gio, 22/09/2005 alle 03.34 -0700, kis zsigmond ha scritto:
> Hy!
>
> I'm connecting to MSSQL from Debian linux using
> unixODBC and the FreeTDS driver. I have a timeout
> problem: if the network connection to the server fails
> after a successfull connection (by SQLConnect) a call
> to SQLQuery blocks until the newtwork connection is
> reestablished. I've set the
> SQL_ATTR_CONNECTION_TIMEOUT and the
> SQL_ATTR_LOGIN_TIMEOUT two. Upon statement execution
> I've set the SQL_ATTR_QUERY_TIMEOUT. No results, the
> query still blocks.
> I'm using the latest stable version of unixODBC and
> FreeTDS 0.63.
>
Fixed in current CVS. No backport planned. James, IMO is time to do a
schedule for 0.64... all note for 0.64 in TODO are not stopover:
Must be fixed in 0.64:
. ctlib parameters, handle all case even in tds7
. handle and test prepared query
(? and @ syntax should be supported)
. cancellation
. ctlib seems to hang reading row while in IDLE state
(tds_peek if not in pending state hang... update)
Broken:
. Passing invalid character set names to server with tsql?
tsql (and so libTDS) can pass invalid charset names to Sybase
libTDS assume Sybase can handle this charset but it's false
and doesn't convert correctly.
Working in progress:
. fix timeout problem reported in ML
. check dblib behavior
these do not works in 0.63 either...
freddy77
More information about the FreeTDS
mailing list