I installed Vertica 6.1.3 CE, the unixODBC package (I'm running RHEL 6.3).
I also downloaded the Linux ODBC drivers from here (https://my.vertica.com/download-community-edition/, under "Individual drivers") and extracted them to /usr/lib64 so that libverticaodbc.so is available there. I did an ldconfig.
Although I can connect with VSQL to a newly created database, I can't succeed in connecting to my Vertica Database : "Could'nt SQLConnect"
I tried using a vertica.ini in /etc, with not more success.
What drivers shall I use ? Am i supposed to use the Vertica 5.1 unixODBC drivers ???
Thank you !
unixODBC and vertica 6.1.3
I also add that I have an odbc.ini and odbcinst.ini in /etc having their Driver directive pointing to /usr/lib64/libverticaodbc.so
Additionnaly, I have odbc.ini and odbcinst.ini pointing to the so file as uncompressed from the linux drivers archive.
I also tried a /etc/vertica.ini file with not more success.
I also tried a /etc/vertica.ini file with not more success.
Looks like the vertica.ini is now mandatory when using the new non-unixODBC-only ODBC drivers.
Nut sure why this file is needed when odbc.ini could do the job but well... Cut-n-pasting the sample in the documentation did the trick.
Nut sure why this file is needed when odbc.ini could do the job but well... Cut-n-pasting the sample in the documentation did the trick.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
