Connection Establishment Timeout for long running queries

Moderator: NorbertKrupa

Post Reply
ajit_nayak
Newbie
Newbie
Posts: 15
Joined: Tue May 14, 2013 1:25 pm

Connection Establishment Timeout for long running queries

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

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1775
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Connection Establishment Timeout for long running querie

Post by JimKnicely » Tue Nov 26, 2013 5:13 pm

See if the following post helps out:

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

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “ADO.NET”