Page 1 of 1

Connection Establishment Timeout for long running queries

Posted: Fri Nov 22, 2013 1:41 pm
by ajit_nayak
Hi,

I have a sql query which is running in vertica for long time . In database editor I cane see the result after 4 hours.
But in my application using ADO.NET throws Exception ('Increase Connection Establishment time .")

I am using vertica 4.1 driver to make connection .
My Connection String is like this

SERVER={server};PORT={port};DATABASE={DBNAme};USER={username};PASSWORD={password};COMMANDTIMEOUT=2000;POOLING=True

Please Somebody reply if knows the solution for this

Thanks
Ajit Kumar Nayak
simpleajit@gmail.com

Re: Connection Establishment Timeout for long running querie

Posted: Tue Nov 26, 2013 5:13 pm
by JimKnicely
See if the following post helps out:

http://www.vertica-forums.com/viewtopic.php?f=33&t=1496