Sample Header Ad - 728x90

SQL Server to MySQL sync, using Workbench, FreeTDS, and iODBC on 10.9

0 votes
1 answer
5125 views
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', ' [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 :-/
Asked by CDD (143 rep)
Jan 14, 2014, 08:54 PM
Last activity: Aug 2, 2015, 09:45 AM