Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem with long queries - on one MSSQL server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] Problem with long queries - on one MSSQL server
  • Date: Sat, 22 Feb 2014 14:24:56 -0500

On Fri, 21 Feb 2014 20:08:49 -0800
Daryl Jones <daryl AT tcomeng.com> 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




Archive powered by MHonArc 2.6.24.

Top of Page