Re: How to install ODBC driver using "Open ODBC Administrator" mentu
Posted by: Jacob Nikom
Date: April 27, 2015 02:13PM

Hi Philip,

Thank you for your help.

It is well known observation that the level of documentation incompleteness is
inversely proportional to the number of people who used it :-)

It looks like more people started to use now, so they noticed some
deficiencies.

First, I would like to say that the new information is very helpful, especially
those snapshots for "ODBC Driver Add/Setup", but also "Generic ODBC driver
Setup" as well.

One thing I did not understand how I can get into "Generic ODBC driver
Setup" window? What is the sequence of clicks that leads me into that
window? I tried to get it by myself and could not find the way.

However, my most important remark is about "Important: using FreeTDS with
iODBC" line on the web page:
http://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-drivers-linux.html

It seems to me that this small section is incorrect.

If you look inside the build_freetds.sh file, it already contains that option
at the line 79:

79 ./configure --disable-apps --disable-server --disable-pool --with-iodbc=/tmp/freetdsbuild --enable-odbc-wide

Second, there is no explanation how to install the packages
libiodbc-devel or libiodbc2-dev

I spent quite a bit of time trying to accomplish it until MySQL people told me
the command that worked very well for my CentOS 6.6:

yum install libiodbc libiodbc-devel

After I ran it the drivers were installed:
/usr/local/lib/libtdsodbc.a
/usr/local/lib/libtdsodbc.la
/usr/local/lib/libtdsodbc.so
/usr/local/lib/libtdsodbc.so.0
/usr/local/lib/libtdsodbc.so.0.0.0


Also I was able to do data migration, but I ran WB on Windows, not on Linux.
Nevertheless I am planning to do that from Linux side once I master
Windows version.

Thanks again for your help and for the good tool.

Best regards,

Jacob Nikom

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.