Having trouble setting up a local ODBC connection.
I am trying to do a migration from MS SQL Server to MySQL (using the migration wizard in MySQL Workbench.)
I have MySQL Workbench loaded. I have MS SQL Server 2012 Express (Advanced) loaded (which includes SQL Server Management Studio 2012.) I have a BAK file from an online database on my local machine. (I do not have the server/database permissions to do the migration on-line at a shared hosting site.)
I have restored the BAK file, so I have a working copy of the SQL Server database, locally, in SQL Server 2012. I cant understand why I cannot create the ODBC connection (MySQL Workbench seems to require an ODBC connection - not sure if there is another way.) I was able to create the ODBC connection for the REMOTE database, but cannot seem to get an ODBC connection to work for the LOCAL database.