Connection Establishment Timeout for long running queries
Posted: Fri Nov 22, 2013 1:41 pm
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
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