Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've been struggling to get the MySQL Workbench to behave properly to complete the following:

With Mavericks (OS X 10.9), connect to a SQL Server and create a migration job to a MySQL server.

The main issue seems to be with ODBC drivers. iODBC was deprecated with 10.8, and the header files removed complete in 10.9 (Some discussion on this here. More in-depth discussion here).

Despite my best efforts, this is the farthest I have gotten in Workbench, when trying to Test the connection to a SQL Server on a local subnet:

The ODBC driver that was selected for the source connection was not found by the ODBC manager.
Ensure that you have the proper ODBC driver installed and retry.

Error Text: Error("('00000', '[00000] [iODBC][Driver Manager]dlopen({FreeTDS}, 6): image not found (0) (SQLDriverConnect)')"): error calling Python module function DbMssqlRE.connect

Here is what I have done up to this point:

  • installed FreeTDS .92.XX from their site (homebrew install of FreeTDS wasn't acceptable, as it uses .91. Apparently .92 or greater is required, according to the Docs I have been following on MySQL, located here

  • Installed the latest iODBC files I could find on iodbc.org (seemingly forgotten since 10.6)

  • Using homebrew, installed unixODBC, just in case that provided some alternative, which did not seem to be of any use either,

  • installed ODBC Administrator App, v 1.1.0 from Apple

Has anyone successfully connected to a SQL Server database as a source, using the Workbench on Mac OS 10.9?

About to give up and opt for the Windows app, because this iODBC stuff is becoming pretty frustrating 5+ hours in :(

Edits

It seems that PuTTY is showing simple telnet and ssh commands over ports 3606 and 22 are not accepted either.

The firewall is completely open on Windows, from what I can tell. Private, Public, and Corporate settings allow for all inbound and outbound traffic.

root and users with a wildcard host are not working either :-/

share|improve this question
    
I have the same issues as you. In order to get past the image not found error, you'll need to add a driver with description FreeTDS in ODBC Administrator. I installed FreeTDS via Homebrew with --HEAD --universal --with-unixodbc and the library ended up at /usr/local/lib/libtdsodbc.so (you need --universal because MySQL Workbench is 32 bit). After that, the connection just wouldn't work. I verified connection from terminal via tsql. In the end I gave up and used MySQL Workbench through VMWare Fusion to get it going, but maybe this info will get you further. –  Nate Pinchot Jan 25 at 16:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.