SSIS ADO.Net Connection issues

Moderator: NorbertKrupa

Post Reply
ako
Newbie
Newbie
Posts: 1
Joined: Mon Mar 03, 2014 7:53 pm

SSIS ADO.Net Connection issues

Post by ako » Tue Apr 15, 2014 6:10 pm

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

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

Re: SSIS ADO.Net Connection issues

Post by JimKnicely » Tue Apr 15, 2014 6:45 pm

Are you connecting to a Vertica DB that is an earlier version than 7.0.1?
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”