Page 1 of 1

SSIS ADO.Net Connection issues

Posted: Tue Apr 15, 2014 6:10 pm
by ako
I have installed vertica-ado-7.0.1-0.32 and I am using Microsoft BIDS - 2008 to create SSIS package.

When I create connection to Vertica database using ADO.Net , Managed Provider - Vertica.Data.VerticaClient I am getting error
"Test connection failed because of an error in initializing provider.[5273] Failed to connect to lps on host <myIP> Reason FATAL: Unsupported protocal 3.4: server supports 3.0 to 3.3"

I have following in connection string - Host=<myIP>;Database=<myDB>;Port=5433;User=<myUser>;;IntegratedSecurity=False;

Any idea?

Thank you

Re: SSIS ADO.Net Connection issues

Posted: Tue Apr 15, 2014 6:45 pm
by JimKnicely
Are you connecting to a Vertica DB that is an earlier version than 7.0.1?