ODBC Connection to Vertica

Comments

• Options

  sKwa

  July 2017 edited July 2017

  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=
  

  0