Default Process Time-out

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
ccampbell
Posts: 31
Joined: Tue 01 Jun 2010 17:31
Location: Oregon

Default Process Time-out

Post by 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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Default Process Time-out

Post by 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.

Post Reply