Installation guide

Contents
3.2.1
Looking for Windows ODBC Drivers ? ................................................ 19
3.2.2 Installing Windows ODBC Drivers ...................................................... 20
3.2.3 Setting up an ODBC Data Source ........................................................ 20
ODBC on 64-bit Windows Versions............................................... 20
3.2.4 ODBC Configuration Files ................................................................... 20
ODBC.INI - ODBC Data Source Configuration............................... 21
[ODBC]..................................................................................... 21
[ODBC Data Sources] ............................................................... 21
ODBCINST.INI - ODBC Driver Configuration................................. 21
[ODBC Drivers] ........................................................................ 21
Windows Registry Keys .................................................................. 21
HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI ............... 21
HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI........ 21
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI.................. 21
3.2.5 Available Data Source Types (DSNs).................................................... 22
User Data Sources (User-DSN) ...................................................... 22
System Data Sources (System-DSN)............................................... 22
File Data Sources (File-DSN) .......................................................... 22
3.2.6 DSN-less Connections......................................................................... 23
Pros and Cons of using DSN-less Connections............................... 23
DNS-less Connection String ........................................................... 23
3.3 Accessing Databases from Unix ........................................24
3.3.1 Looking for Unix ODBC Drivers ?........................................................ 24
3.3.2 mxODBC Connect - a general purpose client-server solution .............. 24
3.3.3 Installing Unix ODBC Drivers.............................................................. 25
3.3.4 Setting up an ODBC Data Source ........................................................ 25
3.3.5 ODBC Configuration Files ................................................................... 26
/etc/odbc.ini - System ODBC Data Source Configuration ............... 26
[ODBC]..................................................................................... 26
[ODBC Data Sources] ............................................................... 27
~/.odbc.ini - User ODBC Data Source Configuration..................... 27
/etc/odbcinst.ini - System ODBC Driver Configuration................... 27
[ODBC]..................................................................................... 27
[ODBC Drivers] ........................................................................ 28
~/.odbcinst.ini - User ODBC Driver Configuration......................... 28
Environment Variables: ODBCINI and ODBCINSTINI .................... 28
ODBCINI .................................................................................. 28
ODBCINSTINI........................................................................... 28