MySQL ODBC driver detection issue by SSMA for MySQL setup

Article
10/22/2012

Question

_{Monday, October 22, 2012 12:36 PM}

Hi,

I have installed mysql connector "mysql-connector-odbc-5.2.2-winx64.msi" and then tried installing SSMA for MySQL 5.2. but get error message while installing SSMA for MySQL 5.2 saying " set up is unable to find Mysql odbc driver v.5.1 and above". I tried with "mysql-connector-odbc-5.1.11-winx64.msi" but still got the same error. I can create the dsn and test the connection successfully with odbc connector. My system is installed with all software of SQL server 2008 r2.

Thanks,
Umakanta

All replies (9)

_{Monday, October 22, 2012 2:09 PM}

Try to install the 32-bit MySQL ODBC Driver.

Maybe you will need Microsoft MDAC (Microsoft Data Access Components (MDAC) 2.8 SP1)

_{Wednesday, October 24, 2012 12:01 PM}

my system is installed with os windows 2008 r2 64bit. and as per ssma for mysql 5.2 pre requisite mysql odbc driver 5.1 and above is required. so will 32bit driver of mysql odbc driver5.1 or 5.2 will work?

From the same system we have already migrated from oracle9i to sql server with no issue. so do we need to install Microsoft Data Access Components (MDAC) 2.8 SP1)?

Thanks,

Umakanta

_{Wednesday, October 24, 2012 4:49 PM}

I suppose you don't need MDAC, but you will need 32-bit MySQL ODBC drivers for SSMA and not the OS.

If it was me, I would install both 32-bit and 64-bit and then try SSMA.

_{Thursday, October 25, 2012 7:13 AM}

Hi irusul,

I Installed 32-bit MySQL ODBC driver also but get the same error "set up is unable to find Mysql odbc driver v.5.1 and above" while installing SSMA for MySQL.

I installing both 32 and 64 bit MySQL ODBC driver 5.2 also, then also I get the same error mentioned above.

Removed all and Installed MySQL ODBC driver 3.5x still got the same error. then installed 3.5 and 5.2 driver of 32 bit then also no resolution on the issue.

Forcefully I installed SSMA for MySQL even if I got the error. But when I opened SSMA GUI and when I clicked on 'Connect to MySQL' tab then got error "... Object is not linked...".

When I clicked on detail tab of error, below is the message:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.SSMA.Framework.Generic.Utilities.DriverVersion..ctor(String version)
   at Microsoft.SSMA.Framework.Generic.Utilities.OdbcDriver..ctor(String driverName, String driver, String driverVer)
   at Microsoft.SSMA.Framework.Generic.Utilities.OdbcDriver..ctor(String driverName, String driver, String driverVer, SupportedPlatform platform, Boolean isTrusted, Boolean isSupported)
   at Microsoft.SSMA.Framework.Generic.Utilities.OdbcDriverUtilities.GetDriverInformationFromList(RegistryKey registryKey, String path, List`1 filteredDriverNames, SupportedPlatform platform, Boolean isSupportedDriver)
   at Microsoft.SSMA.Framework.Generic.Utilities.OdbcDriverUtilities.GetDriverList()
   at Microsoft.SSMA.Framework.Generic.Utilities.OdbcDriverUtilities.GetDrivers(String driver)
   at Microsoft.SSMA.GUI.Generic.Controller.MySql.Dialogs.ConnectMySqlForm.get_OdbcProviders()
   at Microsoft.SSMA.GUI.Generic.Controller.MySql.Dialogs.ConnectMySqlForm.ShowForm(String& outSettings, SecureString& password, String headerText, ConnectionRequirementReason reason)
   at Microsoft.SSMA.GUI.Product.MySqlToMsSql.MySql2MsSql.ConnectToSource(String typeOperation, ConnectionRequirementReason useCase)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5456 (Win7SP1GDR.050727-5400)
    CodeBase:

SSMAforMySql
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.GUI.Components.Controls
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5460 (Win7SP1GDR.050727-5400)
    CodeBase:

System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5456 (Win7SP1GDR.050727-5400)
    CodeBase:

System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5462 (Win7SP1GDR.050727-5400)
    CodeBase:

Microsoft.SSMA.GUI.Product.MainProductWindow
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.GUI.Generic.AbstractGui
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.Generic.XTree
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.Generic.StandardWatsonReport
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.GUI.UIUtils.CommandLine
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.MySql.SqlServer
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.Generic.SSMAEnvironment
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.Generic.Factories
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.GUI.Product.SourceToTarget
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.GUI.Generic.LowLevel
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.GUI.Components.MenuAndToolbar
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

MS.ErrorReporting
    Assembly Version: 2.1.0.0
    Win32 Version:
    CodeBase:

Microsoft.SSMA.Framework.Generic.Utilities
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.GUI.Components.MessageBox
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.MySql.Base
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.SqlServer.Generic
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.Generic.SqlBase.Default
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase:

Microsoft.SSMA.Framework.MySql.Generic
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase:

Microsoft.SSMA.Framework.Generic.Converters.Default
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.Generic.Synchronizers.Default
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.Generic.DataMigrators.Default
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.Generic.DefaultDataMigrationUtils
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.SqlServer.Any2SqlServerGeneric
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.Generic.TreeConverters.Default
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.GUI.Generic.Controller.ControllerMsSql
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.GUI.Generic.Gui.Controller
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.GUI.Generic.Controller.ControllerMySql
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

System.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5460 (Win7SP1GDR.050727-5400)
    CodeBase:

Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase:

System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase:

Microsoft.SSMA.Framework.MySql.Constants
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.MySql.SqlServer.DataMigration.Utils
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.Generic.SqlConstants
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.Generic.Constants
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

Microsoft.SSMA.Framework.SqlServer.Constants
    Assembly Version: 5.2.0.0
    Win32 Version: 5.2.1258.0
    CodeBase:

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Thanks,

Umakanta

_{Thursday, October 25, 2012 11:27 AM}

Do you have Windows Installer 4.5?

_{Friday, October 26, 2012 9:50 AM}

Hi- I have windows installer 4.0 installed on my system.

_{Monday, November 12, 2012 7:10 PM}

Hi,

Have you tried contacting SSMA Support alias, ssmahelp?

See:

http://msdn.microsoft.com/en-us/library/hh413145.aspx

Thanks,

Cathy Miller

_{Friday, November 1, 2013 8:07 AM}

Hi, I have this error too. I tried install 5.1.13 x86 and x64 drivers for ODBC Connection and all fail. But I see unsigned driver 5.2 (without version, company and date in odbc drivers), I remove this driver from registry HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI and install Connector/ODBC 5.2.6 driver from this http://dev.mysql.com/downloads/connector/odbc/ and look only two drivers in ODBC:

MySQL ODBC 5.2 ANSI Driver 5.02.06.00 Oracle Corporation ...

MySQL ODBC 5.2 UNICODE Driver 5.02.06.00 Oracle Corporation ...

And this error has gone!

_{Friday, November 1, 2013 2:16 PM}

I had this issue too and contacted Microsoft support. They stated that this is a long-time and well-known bug. If you're running a 64 bit operating system, make sure you install BOTH the 32 bit and 64 bit drivers. Some software will need the 32 bit, but that won't solve your problem here. If you have both drivers installed, just ignore the error. It will work fine.

Share via

MySQL ODBC driver detection issue by SSMA for MySQL setup

Question

All replies (9)

Additional resources