ODBC - ODBC.ini

1 - About

The odbc.ini file is a unixodbc configuration file that define data sources name (DSN).

Every DSN to which your application connects must have an entry in this file.

3 - Management

3.1 - odbcinst

odbcinst (odbc installer) is the ODBC Installer and Uninstaller command line tool which can create/remove entries in odbc.ini and odbcinst.ini

It can still be done manually.

with odbcinst


odbcinst -j


unixODBC 2.3.2
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /u01/app/oracle/product/fmw/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

3.2 - Location and scope

Location and scope of the data source is done through the location of the file.

3.2.1 - System

System-wide (ie application/process wide) data sources specifications.

The environment parameter ODBCINI configures its path: Example:


export ODBCINI=/u01/app/oracle/product/fmw/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini

3.2.2 - User

User-specific data sources specifications.


$HOME/.odbc.ini
## Equivalent to
~/.odbc.ini

4 - Section

4.1 - ODBC Data Sources

The section [ODBC Data Sources] is use to list the data source defined.


[ODBC Data Sources]
my_new_dsn = Description of my DSN

4.2 - DSN

The DSN section lists:

  • the driver
  • and the driver attributes

Example of a OBIEE DSN:


[my_new_dsn]
Driver = ORACLE_HOME/bifoundation/server/bin/call_interface.library_suffix
ServerMachine = local
Port = bi_server_port_number
ForwardOnlyCursor = No
SelectPhysical = No
Regional = Yes

5 - Help

odbc.ini


man odbc.ini


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap