ODBC connection problems to Vertica

Moderator: NorbertKrupa

Post Reply
femibyte
Newbie
Newbie
Posts: 7
Joined: Thu Jun 14, 2012 4:59 pm

ODBC connection problems to Vertica

Post by femibyte » Fri Sep 07, 2012 7:46 pm

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

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: ODBC connection problems to Vertica

Post by id10t » Mon Sep 10, 2012 11:03 am

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

Post Reply

Return to “ODBC”