Configuring ODBC Connections for Linux
Files
ODBC driver managers use configuration files to define and configure ODBC data sources and drivers. By default, the following configuration files residing in the user’s home directory are used:
.odbc.ini
– The file used to define ODBC data sources (required).odbcinst.ini
– The file used to define ODBC drivers (optional).mapr.hiveodbc.ini
– The file used to configure the Data Fabric ODBC Driver with SQL Connector for Apache Hive (required)
Sample Files
The driver installation contains the following sample configuration files in the Setup directory:
odbc.ini
odbcinst.ini
mapr.hiveodbc.ini
The names of the sample configuration files do not begin with a period (.) so that they will appear in directory listings by default. A filename beginning with a period (.) is hidden. For odbc.ini and odbcinst.ini, if the default location is used, then the filenames must begin with a period (.). For mapr.hiveodbc.ini, the filename must begin with a period (.) and must reside in the user’s home directory. If the configuration files do not already exist in the user’s home directory, then the sample configuration files can be copied to that directory and renamed. If the configuration files already exist in the user’s home directory, then the sample configuration files should be used as a guide for modifying the existing configuration files.