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
SSIS ADO.Net Connection issues
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: SSIS ADO.Net Connection issues
Are you connecting to a Vertica DB that is an earlier version than 7.0.1?
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.