Default Process Time-out

Default Process Time-out

Postby ccampbell » Wed 08 Jan 2014 21:11

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
ccampbell
 
Posts: 29
Joined: Tue 01 Jun 2010 17:31
Location: Oregon

Re: Default Process Time-out

Postby Shalex » Thu 09 Jan 2014 09:32

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.
Shalex
Devart Team
 
Posts: 7781
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL