Options

Can't connect to vertica 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

Anyone have a similar issue?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file