Skip to content

Instantly share code, notes, and snippets.

@dbb613
Last active July 17, 2016 20:32
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dbb613/e76230a1c58af4e02b14 to your computer and use it in GitHub Desktop.
Save dbb613/e76230a1c58af4e02b14 to your computer and use it in GitHub Desktop.
Examples of Vertica ODBC ini files
NOTE: tabs seem to matter under PHP eventhough not for isql
david@OptiPlex-745:/usr/local/etc$ cat odbc.ini
[ODBC Data Sources]verticadsn = VMart
[verticadsn]Description = Vertica Database using ODBC Driver
Driver = /opt/vertica/lib64/libverticaodbc.so
Servername = localhost
Database = VMart
UserName = dbadmin
Password = XXXXXX
Port = 5433
------------
david@OptiPlex-745:/usr/local/etc$ cat odbcinst.ini
[verticadsn]Description = Vertica Database using ODBC Driver
Driver = /opt/vertica/lib64/libverticaodbc.so
-----------
david@OptiPlex-745:/usr/local/etc$ cat vertica.ini
[Driver]DriverManagerEncoding = UTF-16
ODBCInstLib = /usr/local/lib/libodbcinst.so.2.0.0
ErrorMessagesPath = /opt/vertica/lib64
LogLevel = 4
LogPath = /tmp
=================
Set env variables:
export VERTICAINI=/usr/local/etc/vertica.ini
export ODBCINI=/usr/local/etc/odbc.ini
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment