mysql connector ODBC 5.2 not showing on destination drop down

  • I tried to transfer data from ms sql server 2012 to mysql using sql server export, but could not find mysql connector ODBC 5.2 on the distination dropdown. I already have mysql connector ODBC 5.2. Any ideas on how to make it work?

    Thanks.

  • I'm not running 2012 yet, but SSMS (at least in previous versions) is 32-bit only, and therefore the import/export wizard will only see 32-bit MySQL drivers, not 64-bit, so that could be the problem...

    Also, I assume you're aware that the wizard is running client-side, not server-side, so if you're launching it from your client laptop/desktop, that's where the MySQL drivers are required to be installed?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply