ODBC Connection to Vertica

Hi!

How about isql?
https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/ConnectingToHPVertica/ClientODBC/TestingADSNUsingIsql.htm

Can you post:

• vertica version
• perl version
• unixODBC version (on client)
• vertica.ini (on client)
• database locale
• vertica host locale

db locale:

dbadmin=> SELECT GET_CONFIG_PARAMETER('DefaultSessionLocale');
  GET_CONFIG_PARAMETER  
------------------------
 en_US@collation=binary
(1 row)

host locale:

$ locale
LANG=en_US.UTF-8
LANGUAGE=en_US
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC=en_US.UTF-8
LC_TIME=en_US.UTF-8
LC_COLLATE="en_US.UTF-8"
LC_MONETARY=en_US.UTF-8
LC_MESSAGES="en_US.UTF-8"
LC_PAPER=en_US.UTF-8
LC_NAME=en_US.UTF-8
LC_ADDRESS=en_US.UTF-8
LC_TELEPHONE=en_US.UTF-8
LC_MEASUREMENT=en_US.UTF-8
LC_IDENTIFICATION=en_US.UTF-8
LC_ALL=