Setting up drivers on Linux.
FreeTDS version 0.92 or greater is required. Note that many distributions ship older versions of FreeTDS, so it may need to be installed separately. Additionally, the FreeTDS version provided by distributions may also be compiled for the wrong ODBC library (usually to unixODBC instead of iODBC, which MySQL Workbench uses). Because of that you will probably need to build this library yourself.
When compiling FreeTDS for use with iODBC (the default with
the official binaries), you must compile it with the
--enable-odbc-wide command line option
configure script. Failing to do
so will result in crashes and other unpredictable errors.
A script is provided to compile FreeTDS using the options
required for MySQL Workbench You can find it in the
directory in Linux or
folder in the Mac. To use it, follow these steps:
Make sure you have the iODBC headers installed. In Linux,
libiodbc2-dev package from your
distribution. In Mac OS X, the headers come with the
system and no additional action is required for this step.
mkdir ~/freetds to create a directory -
within the users home directory.
build_freetds.sh script to
Get the latest FreeTDS sources from
and place it in the
directory. Make sure to get version 0.92 or newer.
After compilation is done, install it using
install from the path given by the script.
Install the driver in the ODBC Administrator, to make the
ODBC subsystem to recognize it. The name of the driver
libtdsodbc.so and is located
Once the driver is installed, you should be able to create data sources for it from the ODBC Administrator GUI.
When using FreeTDS,
needed in the connection string. If you pick a FreeTDS
specific connection method option in the connection dialog,
that option is added to the connection string automatically.