I'm trying to configure a Vertica 6 ODBC connection on Linux. I've already installed the driver. I believe I have everything set up properly but I get an error testing a connection with isql:
Code: Select all
[root@verticatst01 etc]# isql -v vertica_test
[28000][unixODBC]FATAL 3781: Invalid username or password
[ISQL]ERROR: Could not SQLConnect
Code: Select all
[root@verticatst01 etc]# cat /etc/odbc.ini
[vertica_test]
Description = Warehouse Database
Driver = /opt/vertica/lib64/libverticaodbc.so
Database = vtest
Servername = verticatst01
UID = dbadmin
PWD =
Port = 5433
ConnSettings =
Locale = en_GB
Code: Select all
[root@verticatst01 etc]# /opt/vertica/bin/vsql -U dbadmin
Welcome to vsql, the Vertica Analytic Database interactive terminal.
Type: \h for help with SQL commands
\? for help with vsql commands
\g or terminate with semicolon to execute query
\q to quit
dbadmin=>
Thanks a bunch!