We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


unable to connect to vertica 6.1 using SQLAPI — Vertica Forum

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



Leave a Comment

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