Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Le 21/05/12 18:34, Jonathan Ryshpan a écrit :


My particular system runs KDE, which requires iodbc for many
applications, so that is what I am using for the database interface.
Iodbc has two kinds of configuration files in two places, namely:

These are the system DSN and ODBC configuration files. You generally
need root/sudo access to change these files.

        ~/.odbcinst.ini  (maybe not used)

These are the hidden, user DSN and ODBC configuration files. These files
are used as a fallback, or in addition, if nothing is defined in the
system DNS/ODBC configuration files.

The iodbc web site has info about ~/.odbc.ini, and by implication
about /etc/odbc.ini, which contains (I believe) default info; but it has
nothing about /etc/odbcinst.ini.  Can someone enlighten me about the
relation about these files and what they are used for?

odbcinst.ini defines the name of the ODBC drivers present on the system,
and the locations/libraries to be used when an ODBC connection protocol
is invoked by a third party application, see the examples below that I
have on my Macbook :

[ODBC Drivers]
Actual SQL Server            = Installed
Actual Open Source Databases = Installed
Actual Oracle                = Installed
Actual Access                = Installed
MySQL ODBC 5.1 Driver        = Installed

[Actual SQL Server]
Driver = /Library/ODBC/Actual SQL Server.bundle/Contents/MacOS/
Setup  =

[Actual Open Source Databases]
Driver = /Library/ODBC/Actual Open Source
Setup  =

[Actual Oracle]
Driver = /Library/ODBC/Actual Oracle.bundle/Contents/MacOS/
Setup  =

[Actual Access]
Driver = /Library/ODBC/Actual Access.bundle/Contents/MacOS/
Setup  =

[MySQL ODBC 5.1 Driver]
Driver = /usr/local/lib/
SETUP  = /usr/local/lib/

odbc.ini defines the connection parameters to access a given data source
name (DSN), see my example below for my Macbook :

[ODBC Data Sources]
Actual_MAMP = Actual Open Source Databases
myodbc      = MySQL ODBC 5.1 Driver
IPDB_MAMP   = MySQL ODBC 5.1 Driver
ipdatabase  = MySQL ODBC 5.1 Driver

Trace         = 0
TraceAutoStop = 0
TraceFile     =
TraceLibrary  =

Driver       = /Library/ODBC/Actual Open Source
Description  = Actual Driver to MAMP
Database     = ipdatabase
Server       = localhost
Port         = 8889
IncludeViews = Yes
UserID       = alex
UseKeychain  = Yes

Driver      = /usr/local/lib/
Description = Generic myodbc connection
SERVER      = localhost
PORT        = 3306

Driver      = /usr/local/lib/
Description = MyODBC Connection via Mamp port
Server      =
Port        = 8889

Driver      = /usr/local/lib/
Description = IP management db
Server      =
Port        = 3306

Entries defined in /etc/ are system-wide, i.e. in theory available to
every user declared on the system, entries put in the local user file
are only available to that particular user.


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.