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
Last activity: Aug 2, 2015, 09:45 AM