Page 1 of 1

ODBC connection problems to Vertica

Posted: Fri Sep 07, 2012 7:46 pm
by femibyte
I'm trying to connect to our production database server using Vertica and I am getting this error:

Code: Select all

[08000][unixODBC][Vertica][VerticaDSII] (160) Connection attempt failed: FATAL:  unsupported frontend protocol 3.2: server supports 3.0 to 3.1

[ISQL]ERROR: Could not SQLConnect
Our prod database is version 5.1. I am able to successfully connect to our dev server which is version 6.0. The ODBC client I am using is 5.1.1.
I suspect that somehow the client I am using is unsupported by Vertica 5.1 so I'm thinking of downgrading, maybe to 4.1. Can someone point me to where I can download version 4.1 of the Vertica ODBC client?

Thanks

Re: ODBC connection problems to Vertica

Posted: Mon Sep 10, 2012 11:03 am
by id10t
Hi!

>>I suspect that somehow the client I am using is unsupported by Vertica 5.1
Can you provide next info:

Code: Select all

rpm -qa | grep -i unixODBC
rpm -qa | grep -i pyodbc
python -V
>>Can someone point me to where I can download version 4.1 of the Vertica ODBC client?
1. Log in to myVertica portal
2. Go to Downloads tab
3. In the right side look for: Other Vertica Versions section
Image
Image