Issues with vertica 7.0 linux driver

Moderator: NorbertKrupa

Post Reply
Roopalini
Newbie
Newbie
Posts: 13
Joined: Sun Jan 26, 2014 9:40 pm

Issues with vertica 7.0 linux driver

Post by Roopalini » Wed Jan 29, 2014 9:12 pm

Forum,

I am getting the following error while trying to connect to vertica 7.0. Can someone throw some light on why we are getting the issue?


Error
--------

Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [08001:-1: on HDBC] [DSI] The error message VConnectFailed could not be found in the en-US locale. Check that /en-US/VerticaMessages.xml exists. [01S00:10101: on HDBC] Invalid connection string attribute: FakeOidIndex [01S00:10101: on HDBC] Invalid connection string attribute: Protocol [01S00:10101: on HDBC] Invalid connection string attribute: RowVersioning [01S00:10101: on HDBC] Invalid connection string attribute: ShowOidColumn [01S00:10101: on HDBC] Invalid connection string attribute: ShowSystemTables [01S00:10101: on HDBC] Invalid connection string attribute: Trace [01S00:10101: on HDBC] Invalid connection string attribute: TraceFile

DSN used
------------
[C003_Vertica_MD]
Description=Vertica
Driver=/opt/vertica/lib/libverticaodbc.so
Trace=No
TraceFile=sql.log
Database=SUPER_APP_DEV_MD
Servername=C003WMDP01NA01
UserName=yyc000mstrwhdb
Password=
Port=5433
Protocol=7.4
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ShowOidColumn=No
FakeOidIndex=No
ConnSettings=
TxnReadCommitted=0

[C003_Vertica_WH]
Description=Vertica
Driver=/opt/vertica/lib/libverticaodbc.so
Trace=No
TraceFile=sql.log
Database=C000_TEST_WH
Servername=C000VRT01NA01
UserName=yyc000mstrwhdb
Password=
Port=5433
Protocol=7.4
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ShowOidColumn=No
FakeOidIndex=No
ConnSettings=
TxnReadCommitted=0

Post Reply

Return to “ODBC”