unable to connect to vertica 6.1 using SQLAPI
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
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
0