Hi, I updated my vertica driver from 4.1 to 6.1, but have since been unable to connect to the vertica database using SQLAPI
in my program I have
#include <SQLAPI.h>
SAConnection verticaConn
verticaConn.Connect(Driver=Vertica;Servername=VerticaDev;PORT=5433;Database=VerticaDev;Username=dbadmin;Password=stuff,"","");
which is unable to connect to vertica, and splits out "ERROR 1918854944 Connection::SQLDriverConnect: [Vertica][ODBC] (10360) Invalid connection string" into my vertica_odbc_conn.log
however, if I use SQLDriverConnect() directly, with the EXACT same connection string, I am able to connect to vertica. I have also tried using variations of:
DRIVER=Vertica;SERVER=VerticaDev;PORT=5433;DATABASE=VerticaDev;UID=dbadmin;PWD=stuff
my vertica.ini is
[Driver]DriverManagerEncoding=UTF-16
ODBCInstLib=/usr/lib64/libodbcinst.so
ErrorMessagesPath=/opt/vertica/lib64/en-US
LogLevel=4
LogPath=/tmp
my odbcinst.ini is
[ODBC Drivers]FreeTDS = Installed
[FreeTDS]
Description = FreeTDS iODBC Driver
Driver = /usr/lib64/libtdsodbc.so.0
Setup = /usr/lib64/libtdsodbc.so.0
[SQL Server]
Description = FreeTDS iODBC Driver
Driver = /usr/lib64/libtdsodbc.so.0
Setup = /usr/lib64/libtdsodbc.so.0
[Vertica]
Description = Vertica iODBC Driver
Driver = /opt/vertica/lib64/libverticaodbc.so
I was on version 3.8.2 of SQLAPI, I've since tried the newest version, but same results
Please help
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.