Re: Problem with long queries - on one MSSQL server

"James K. Lowden" <[email protected]> Sat, 22 Feb 2014 14:24:56 -0500

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<[email protected]>

On Fri, 21 Feb 2014 20:08:49 -0800
Daryl Jones <[email protected]> wrote:

> 19:44:12.359664 11900 (write.c:137):tds_put_string converting 722
...
> 19:45:12.425125 11900 (util.c:315):tdserror(0x1a21930, 0x7f2f9c1642a0, 20003, 0)
> 19:45:12.425307 11900 (dblib.c:7874):dbperror(0x7f2f9c163800, 20003, 0)
> 19:45:12.425339 11900 (dblib.c:7927):20003: "Adaptive Server
> connection timed out"
> 19:45:12.425356 11900 (dblib.c:7948):"Adaptive Server connection timed
> out", client returns 2 (INT_CANCEL)

It looks like you've set dbsettime to 60 seconds, and that your query takes longer than that to execute.  

If you're sure the server is responding within that time, I would look for some communication interference, perhaps a firewall.  

HTH.  

--jkl