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
Default Process Time-out
Re: Default Process Time-out
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.
If this doesn't help, specify the call stack of the error with all inner exceptions.