Page 1 of 1

Default Process Time-out

Posted: Wed 08 Jan 2014 21:11
by ccampbell
Hi, using dotConnect for Postgres version 6 and above, PostgresQL 9.3.2, and VS.Net 2010

I'm wondering if there is a setting on the pgConnection object that determines how long a process can execute before timing out. I'm not referring to the "ConnectionTimeout" setting that determines how long it attempts to "establish" a connection. I've got a good connection when I issue the SQL command, but if the process takes over 30 minutes, it's crashing out with an error stating that it "Cannot find table 0".

I've verified that there is nothing on the PostgreSQL side causing this issue.

I'm leaning more towards a network issue but thought I would check to here as well.

Thanks,

Chris

Re: Default Process Time-out

Posted: Thu 09 Jan 2014 09:32
by Shalex
Please set the Default Command Timeout connection string parameter to control the time to wait while trying to execute a command before terminating the attempt and generating an error.

If this doesn't help, specify the call stack of the error with all inner exceptions.