Mac Iodbc Driver For Myysql 5.6.39

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. This is the source for mysql connector/odbc myodbc, an odbc 3.51 driver for connecting an odbc-aware application to the mysql server. Developers number one connection strings reference knowledge base q & a forums about contribute log in. Mysql has also provided us with huge cost savings, which we have been able to funnel into other resources. Installing the MySQL Connector/J driver is relatively easy, you just have to place the jar file on your classpath by specifying it with the “-cp” feature from the command-line. MySQL Connector/J is developed using the Java programming language and can be run on Mac OS X, Windows and Linux. MySQL Connector/ODBC Developer Guide / Configuring Connector/ODBC / Configuring a Connector/ODBC DSN on macOS 5.4 Configuring a Connector/ODBC DSN on macOS To configure a DSN on macOS, you can either use the command-line utility ( myodbc-installer ), edit the odbc.ini file within the Library/ODBC directory of the user, or use the ODBC.

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.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

5.3

Odbc Sql 13 Driver Download

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 [email protected]

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.

Mac OS X builds of 3.52.10

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

Mysql Odbc Driver 5.3

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: Feedbackalienware user support.

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

sourceforge

Source 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

source tarballlibiodbc-3.51.1.tar.gz
RedHat Source RPMlibiodbc-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 onlylibiodbc-3.51.0.tar.gz
3.0.6 source onlylibiodbc-3.0.6.tar.gz
3.0.5 source onlylibiodbc-3.0.5.tar.gz
3.0.4 source onlylibiodbc-3.0.4.tar.gz
3.0.3 source onlylibiodbc-3.0.3.tar.gz
3.0.2 source onlylibiodbc-3.0.2.tar.gz
3.0.1 source onlylibiodbc-3.0.1.tar.gz
3.0.0 source onlylibiodbc-3.0.0.tar.gz

Original 2.x Versions

2.50.3 source onlylibiodbc-2.50.3.tar.gz
2.50.2 source onlylibiodbc-2.50.2.tar.gz
2.50 source onlylibiodbc-2.50.tar.gz
-->

This article explains how to install the Microsoft ODBC Driver for SQL Server on macOS. It also includes instructions for the optional command-line tools for SQL Server (bcp and sqlcmd) and the unixODBC development headers.

This article provides commands for installing the ODBC driver from the bash shell. If you want to download the packages directly, see Download ODBC Driver for SQL Server.

Microsoft ODBC 17

To install Microsoft ODBC driver 17 for SQL Server on macOS, run the following commands:

Important

If you installed the v17 msodbcsql package that was briefly available, you should remove it before installing the msodbcsql17 package. This will avoid conflicts. The msodbcsql17 package can be installed side by side with the msodbcsql v13 package.

Mysql odbc driver 5.1

Previous versions

The following sections provide instructions for installing previous versions of the Microsoft ODBC driver on macOS.

ODBC 13.1

Use the following commands to install the Microsoft ODBC driver 13.1 for SQL Server on OS X 10.11 (El Capitan) and macOS 10.12 (Sierra):

Driver files

The ODBC driver on macOS consists of the following components:

ComponentDescription
libmsodbcsql.17.dylib or libmsodbcsql.13.dylibThe dynamic library (dylib) file that contains all of the driver's functionality. This file is installed in /usr/local/lib/.
msodbcsqlr17.rll or msodbcsqlr13.rllThe accompanying resource file for the driver library. This file is installed in [driver .dylib directory]./share/msodbcsql17/resources/en_US/ for Driver 17 and in [driver .dylib directory]./share/msodbcsql/resources/en_US/ for Driver 13.
msodbcsql.hThe header file that contains all of the new definitions needed to use the driver.
Note: You cannot reference msodbcsql.h and odbcss.h in the same program.
msodbcsql.h is installed in /usr/local/include/msodbcsql17/ for Driver 17 and in /usr/local/include/msodbcsql/ for Driver 13.
LICENSE.txtThe text file that contains the terms of the End-User License Agreement. This file is placed in /usr/local/share/doc/msodbcsql17/ for Driver 17 and in /usr/local/share/doc/msodbcsql/ for Driver 13.
RELEASE_NOTESThe text file that contains release notes. This file is placed in /usr/local/share/doc/msodbcsql17/ for Driver 17 and in /usr/local/share/doc/msodbcsql/ for Driver 13.

Resource file loading

The driver needs to load the resource file in order to function. This file is called msodbcsqlr17.rll or msodbcsqlr13.rll depending on the driver version. The location of the .rll file is relative to the location of the driver itself (so or dylib), as noted in the table above. As of version 17.1 the driver will also attempt to load the .rll from the default directory if loading from the relative path fails. The default resource file path on macOS is /usr/local/share/msodbcsql17/resources/en_US/

Troubleshooting

Some users encounter an issue when trying to connect after installing the ODBC driver and receive an error like: '[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)'. It may be the case that unixODBC is not configured correctly to find registered drivers. In these cases, creating a couple symbolic links can resolve the issue.

For additional cases where you are unable to make a connection to SQL Server using the ODBC driver, see the known issues article on troubleshooting connection problems.

Next steps

After installing the driver, you can try the C++ ODBC example application. For more information about developing ODBC applications, see Developing Applications.

For more information, see the ODBC driver release notes and system requirements.