Dear people,
When I try a:
library(vRODBC)
connect <- odbcConnect("VerticaDSN")
I get the following error:
Warning messages:
1: In odbcDriverConnect("DSN=VerticaDSN") :
[vRODBC] ERROR: state HY000, code 11560, message [unixODBC][Vertica][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function.
2: In odbcDriverConnect("DSN=VerticaDSN") : ODBC connection failed
Now I've searched everywhere on the internet for solutions as well as the docs provided by HPE, but never do I find a solution that works for me.
Now I know that it's related to the two .ini files you need to create, so first I'll show those:
/etc/odbc.ini
[ODBC Data Sources]
VerticaDSN = "Vertica"
[VerticaDSN]
Description = DSN for Vertica
Driver = /opt/hp/odbc/lib64/libverticaodbc.so
Database = VMart
Servername = localhost
UserName = dbadmin
Password = <omitted>
Port = 5433
ConnSettings =
Locale = en_US
[Driver]
DriverManagerEncoding = UTF-16
ODBCInstLib = /usr/lib/x86_64-linux-gnu/libodbcinst.so
ErrorMessagesPath = /opt/vertica/lib64
LogLevel = 0
LogPath = /tmp
/etc/vertica.ini
[Driver]
DriverManagerEncoding = UTF-16
ODBCInstLib = /usr/lib/x86_64-linux-gnu/libodbcinst.so
ErrorMessagesPath = /opt/vertica/lib64
LogLevel = 0
LogPath = /tmp
Both the system variables for $VERTICAINI and $ODBCINI are set and also in the .bashrc, as well as the Renviron has been set to:
VERTICAINI=/etc/verticaini.ini
ODBCINI=/etc/odbc.ini
Secondly, the paths that need to resolve to an actual file are all correct, as in, the file is actually in the place as listed in both .ini's.
The path for ErrorMessages also leads to a folder containing an en-US folder with in the folder the file ODBCMessages.xml.
I honestly do not how to solve it. Anybody who can help me with this?
(I'm running Ubuntu 14.04 LTS)
(As well as the vertica.ini fyi)
