FreeTDS Development Group

["Thomas, Christopher (LLU)" <cwthomas AT llu.edu>]

In your php.ini file, set the "mssql.timeout" property to a value higher than 
60

Chris

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org 
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: Saturday, February 22, 2014 11:25 AM
To: freetds AT lists.ibiblio.org
Subject: Re: [freetds] Problem with long queries - on one MSSQL server

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
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds