Command Timeout Issue
Posted: Thu 01 Nov 2012 23:16
I am getting the dreaded "Server did not respond within the specified timeout interval." when filling a DataSet. I have set the "Default Command Timeout=0" within the connection string and have verified through the dbMonitor that all connections in the Pool have the "Default Command Timeout" set.
I know the "Default Command Timeout" is working sometimes because I have written a Postgres function that will wait 40 seconds before responding and it works just fine when called outside of a DataSet.
I have tested this with versions 5.80.350 (Licensed) and 6.2.104.0 (Trial)
Lloyd Albin
Fred Hutchinson Cancer Research Center
www.fhcrc.org
Seattle Postgres Users Group
www.seapug.org
I know the "Default Command Timeout" is working sometimes because I have written a Postgres function that will wait 40 seconds before responding and it works just fine when called outside of a DataSet.
I have tested this with versions 5.80.350 (Licensed) and 6.2.104.0 (Trial)
Lloyd Albin
Fred Hutchinson Cancer Research Center
www.fhcrc.org
Seattle Postgres Users Group
www.seapug.org