IODBC is a cross-platform Driver Manager that comforms to the Microsoft ODBC 2.x & 3.x and X/Open SQL CLI data access specs. IODBC Driver Manager and SDK enables the development of database-centric solutions that are both database and platform independent. Independent Open DataBase Connectivity for Linux, MacOS X and Unix systems.
Enabling tracing at the driver-manager level is a useful way to troubleshoot ODBC driver issues. In this article, I’ll explain how to enable tracing for each of the driver managers to help in ODBC troubleshooting tasks.
What is ODBC Manager for Mac ODBC Manager is a replacement for Apple's ODBC administrator utility, which is no longer included with Mac OS X (starting with Snow Leopard). ODBC Manager also addresses some of the problems and annoyances of Apple's administrator, including the use of underscores in names and keywords.
You can choose from several driver managers, depending on the platform that you’re using.
Jump to unixODBC Driver Manager
Jump to iODBC Driver Manager (Mac OSX)
For information on enabling driver logging, see How do I enable logging in an ODBC driver?
Windows
This article does a nice job of explaining how to enable tracing, however, you can follow these simple steps if you don’t want the extra detail:
- Open the ODBC Administrator. See here for how to open the proper ODBC Administrator depending on driver bitness.
- Change to the Tracing tab.
- Change the “Log File Path” field to be the location and name of the file to which you’d like to write the trace entries.
- Optional: Check the “Machine-wide tracing for all user identities” if you want the tracing to affect all users on the machine. This is useful if you want to trace things like SSIS which can run processes under separate users. If you are unsure, check this box.
- Hit the “Start Tracing Now” button. Tracing will become active only for applications started after tracing has started; currently-executing applications will not have tracing enabled. You must restart applications to have tracing enabled. You may need to restart services for applications which run separate processes such as SSIS, or you may have to restart the machine to properly enable tracing.
- Once you are done gathering a trace, disable tracing: Return to the Tracing tab in the ODBC Administrator and hit “Stop Tracing Now”, as tracing will consume disk space and significantly impact performance. Again, this will not affect currently-executing applications, only newly-started applications, so you may need to restart some applications.
Other Platforms – unixODBC
unixODBC is generally used on platforms other than Windows and OSX, although iODBC (see below) is sometimes also used. Here’s how to enable trace-logging:
- Locate your odbcinst.ini file. Generally this is located within your home directory, and it may be a hidden file.
- Under the section heading [ODBC] (add the heading if it does not exist) add the key-value pairs:
- Trace=yes
- TraceFile = /path/to/file/name.log
An example of what this would look like:
- You must restart applications after you add these entries before tracing will start. Once you are done gathering a trace, remember to disable tracing by changing the value of Trace to “no” in the odbcinst.ini file, as tracing will consume disk space and significantly impact performance. Again, this will not affect currently-executing applications, only newly-started applications, so you may need to restart some applications.
OSX and Other Platforms – iODBC
iODBC the default driver manager on OSX, and can sometimes be found on other non-Windows platforms. Enable trace logging by following the instructions below:
- Locate your odbc.ini file. Generally this is located within your home directory, and it may be a hidden file.
- Under the section heading [ODBC] (add the heading if it does not exist) add the key-value pairs:
- Trace=1
- TraceFile=/path/to/file/traceFile.log
- Debug=1
- DebugFile=/path/to/file/debugFile.log
An example of what this would look like:
- You must restart applications after you add these entries before tracing will start. Once you are done gathering a trace, remember to disable tracing by changing the value of Trace and Debug to “0” in the odbc.ini file, as tracing will consume disk space and significantly impact performance. Again, this will not affect currently-executing applications, only newly-started applications, so you may need to restart some applications.
Table of Contents
You can download the iODBC driver manager from either this page or using Git.
The file file-md5sums.txt contains known-good MD5 hashes of components you download.
Stable Version 3.52.14
The sources for the iODBC Driver Manager are available as a tarball on SourceForge or by checkout from Github; you can also read the ChangeLog.
Stable Version 3.52.12
The sources for the iODBC Driver Manager are available as a tarball on SourceForge or by checkout from Github; you can also read the ChangeLog.
Mac OS X
This package contains iODBC as a Framework plus the GUI iODBC Administrator.app, and includes full 64-bit support at all levels, as required by Microsoft Office 2016 (v15.25+) and various other newer tools.
| Mojave (10.14.x), High Sierra (10.13.x), Sierra (10.12.x), El Capitan (10.11.x), Yosemite (10.10.x), Mavericks (10.9.x), Mountain Lion (10.8.x), Lion (10.7.x) | mxkozzzz.dmg |
Packages for Linux Distributions
Ubuntu and Debian GNU/Linux have packages for iodbc:
Gentoo also has a package for libiodbc.
Unix binaries
The iODBC Developers Open Source Release archive is portable to all major UNIX platforms including Solaris, HP-UX, AIX, SCO OpenServer, SCO Unixware, SGI IRIX (Mips ABI), Digital Unix, DG-UX, Dynix/PTX, BSDI, and FreeBSD.
OpenLink's Software Availability page contains pre-compiled OpenLink-branded iODBC SDKs for several OS platforms. If you are interested in binary releases for other platforms, please email us at iodbc@openlinksw.com.
We are also looking for porting volunteers for OpenVMS, OS400 and OS390, if you'd like to help out!
Previous Versions
3.52.11
This version was never publicly released but its changes are retained in the subsequent 3.52.12 release.
3.52.10
The sources for the iODBC Driver Manager are available for download or by checkout from Github, or for download as a tarball on SourceForge ; you can also read the ChangeLog.
Iodbc Driver Manager Administrator Sdk Download
Mac OS X builds of 3.52.10
Iodbc Administrator
This package contains iODBC as a Framework plus the GUI iODBC Administrator.app and bindings for Microsoft Office:
| Snow Leopard (10.6.x), Leopard (10.5.x) | mvkozzzz.dmg |
3.52.9
The sources for the iODBC Driver Manager are available as a tarball on SourceForge or by checkout from Github; you can also read the ChangeLog.
3.52.8
The sources for the iODBC Driver Manager are available as a tarball on SourceForge or by checkout from Github; you can also read the ChangeLog.
3.52.7
The sources for the iODBC Driver Manager are available as a tarball, libiodbc-3.52.7.tar.gz or from SourceForge.You can also view the ChangeLog.
Source of 3.52.7
| File | Download |
|---|---|
| iODBC Source tarball | libiodbc-3.52.7.tar.gz |
| Linux source RPM | libiodbc-3.52.7-1.src.rpm |
Mac OS X builds of 3.52.7
This package contains iODBC as a Framework plus the graphical ODBC configuration administrator and bindings for Microsoft Office:
| Snow Leopard (10.6.x), Leopard (10.5.x) | iodbc-sdk-3.52.7-macosx-10.5.dmg |
| Tiger (10.4.x) | iodbc-sdk-3.52.7-macosx-10.4.dmg |
This package contains a bug-fix for the version of iODBC provided by Apple, installing in /usr; this is recommend for compiling interfaces such as PerlDBD::ODBC, the Ruby ODBC bridge and PHP:
| Snow Leopard (10.6.x), Leopard (10.5.x) | iodbc-usr-sdk.zip |
3.52.6
Source of 3.52.6
The sources for the iODBC Driver Manager are available as a tarball, libiodbc-3.52.6.tar.gz or from SourceForge . You can also view the ChangeLog .
RedHat Linux RPMs of 3.52.6
| iODBC Driver Manager and Administrator Source release (SRPM) | libiodbc-3.52.6-1.src.rpm |
| iODBC Driver Manager RPM (RedHat Linux 9) | libiodbc-3.52.6-1.i386.rpm |
| iODBC Administrator (RedHat Linux 9) | libiodbc-admin-3.52.6-1.i386.rpm |
| iODBC RPM Developers Kit (RedHat Linux 9) | libiodbc-devel-3.52.6-1.i386.rpm |
3.52.5
Source of 3.52.5
The sources for the iODBC Driver Manager are available as a tarball, libiodbc-3.52.5.tar.gz or from SourceForge . You can also view the ChangeLog.
RedHat Linux RPMs of 3.52.5
| iODBC Driver Manager and Administrator Source release (SRPM) | libiodbc-3.52.5-1.src.rpm |
| iODBC Driver Manager RPM (RedHat Linux 9) | libiodbc-3.52.5-1.i386.rpm |
| iODBC Administrator (RedHat Linux 9) | libiodbc-admin-3.52.5-1.i386.rpm |
| iODBC RPM Developers Kit (RedHat Linux 9) | libiodbc-devel-3.52.5-1.i386.rpm |
3.52.4
Source of 3.52.4
The sources for the iODBC Driver Manager are available as a tarball, libiodbc-3.52.4.tar.gz or from SourceForge.You can also view the ChangeLog.
RedHat Linux RPMs of 3.52.4
| iODBC Driver Manager and Administrator Source release (SRPM) | libiodbc-3.52.4-1.src.rpm |
| iODBC Driver Manager RPM (RedHat Linux 9) | libiodbc-3.52.4-1.i386.rpm |
| iODBC Administrator (RedHat Linux 9) | libiodbc-admin-3.52.4-1.i386.rpm |
| iODBC RPM Developers Kit (RedHat Linux 9) | libiodbc-devel-3.52.4-1.i386.rpm |
3.52.3
Source of 3.52.3
The sources for the iODBC Driver Manager are available as a tarball, libiodbc-3.52.3.tar.gz or from SourceForge . You can also view the ChangeLog .
RedHat Linux RPMs of 3.52.3
| iODBC Driver Manager and Administrator Source release (SRPM) | libiodbc-3.52.3-1.src.rpm |
| iODBC Driver Manager RPM (RedHat Linux 9) | libiodbc-3.52.3-1.i386.rpm |
| iODBC Administrator (RedHat Linux 9) | libiodbc-admin-3.52.3-1.i386.rpm |
| iODBC RPM Developers Kit (RedHat Linux 9) | libiodbc-devel-3.52.3-1.i386.rpm |
3.52.2
sourceforgeSource of 3.52.2
The sources for the iODBC Driver Manager are available as a tarball, libiodbc-3.52.2.tar.gz or from SourceForge .
Linux RPMs of 3.52.2
| iODBC Driver Manager and Administrator Source release (SRPM) | libiodbc-3.52.2-1.src.rpm |
| iODBC Driver Manager RPM (RedHat Linux 9) | libiodbc-3.52.2-1.i386.rpm |
| iODBC Administrator (RedHat Linux 9) | libiodbc-admin-3.52.2-1.i386.rpm |
| iODBC RPM Developers Kit (RedHat Linux 9) | libiodbc-devel-3.52.2-1.i386.rpm |
3.52.1
Source of 3.52.1
The sources for the iODBC Driver Manager are available as a tarball, libiodbc-3.52.1.tar.gz or from SourceForge .
Linux RPMs of 3.52.1
| iODBC Driver Manager and Administrator Source release (SRPM) | libiodbc-3.52.1-1.src.rpm |
| iODBC Driver Manager RPM (RedHat Linux 9) | libiodbc-3.52.1-1.i386.rpm |
| iODBC Administrator (RedHat Linux 9) | libiodbc-admin-3.52.1-1.i386.rpm |
| iODBC RPM Developers Kit (RedHat Linux 9) | libiodbc-devel-3.52.1-1.i386.rpm |
3.51.2
Source of 3.51.2
The sources for the iODBC Driver Manager are available as a tarball, libiodbc-3.51.2.tar.gz or from SourceForge .
Linux RPMs of 3.51.2
| iODBC Driver Manager and Administrator Source release (SRPM) | libiodbc-3.51.2-1.src.rpm |
| iODBC Driver Manager RPM (RedHat Linux 9) | libiodbc-3.51.2-1.i386-rh9.rpm |
| iODBC Administrator (RedHat Linux 9) | libiodbc-admin-3.51.2-1.i386-rh9.rpm |
| iODBC RPM Developers Kit (RedHat Linux 9) | libiodbc-devel-3.51.2-1.i386-rh9.rpm |
3.51.1
Iodbc Driver Manager Administrator Sdk Free
| source tarball | libiodbc-3.51.1.tar.gz |
| RedHat Source RPM | libiodbc-3.51.1-1.src.rpm |
| iODBC Driver Manager RPM (RedHat Linux 8) | libiodbc-3.51.1-1.i386-rh8.rpm |
| iODBC Driver Manager RPM (RedHat Linux 9) | libiodbc-3.51.1-1.i386-rh9.rpm |
| iODBC Administrator (RedHat Linux 8) | libiodbc-admin-3.51.1-1.i386-rh8.rpm |
| iODBC Administrator (RedHat Linux 9) | libiodbc-admin-3.51.1-1.i386-rh9.rpm |
Older Versions
We provide these historical releases in source form only.
Legacy 3.x
| 3.51.0 source only | libiodbc-3.51.0.tar.gz |
| 3.0.6 source only | libiodbc-3.0.6.tar.gz |
| 3.0.5 source only | libiodbc-3.0.5.tar.gz |
| 3.0.4 source only | libiodbc-3.0.4.tar.gz |
| 3.0.3 source only | libiodbc-3.0.3.tar.gz |
| 3.0.2 source only | libiodbc-3.0.2.tar.gz |
| 3.0.1 source only | libiodbc-3.0.1.tar.gz |
| 3.0.0 source only | libiodbc-3.0.0.tar.gz |
Original 2.x Versions
| 2.50.3 source only | libiodbc-2.50.3.tar.gz |
| 2.50.2 source only | libiodbc-2.50.2.tar.gz |
| 2.50 source only | libiodbc-2.50.tar.gz |