Remove From My Forums

SQL Server Migration Assistant for MySQL - System.NullReferenceException

Discussion générale
0

Connectez-vous pour voter

Bonjour,

Bonjour,

Mon but est de migré ma base MySQL en SQL Server.

Pour cela, j'ai installé sur mon Windows 7 pro x64 :
- SQL Server EXPRESS 2008 R2 SP2 64 bits
- SQL Server Management Studio 2008
- SSMA for MySQL 5.2 + extension pack
- Drivers ODBC MySQL (mysql-connector-odbc-5.2.2-win32.msi & mysql-connector-odbc-5.2.2-winx64.msi)

Ensuite, je lance SQL Server Migration Assistant for MySQL et je cré un nouveau projet.
Je click sur Connect to MySQL et j'obtient l'erreur suivante :
Consultez la fin de ce message pour plus de détails sur l'appel du débogage
juste-à-temps (JIT) à la place de cette boîte de dialogue.

************** Texte de l'exception **************
System.NullReferenceException: La référence d'objet n'est pas définie à une instance d'un objet.
   à Microsoft.SSMA.Framework.Generic.Utilities.DriverVersion..ctor(String version)
   à Microsoft.SSMA.Framework.Generic.Utilities.OdbcDriver..ctor(String driverName, String driver, String driverVer)
   à Microsoft.SSMA.Framework.Generic.Utilities.OdbcDriver..ctor(String driverName, String driver, String driverVer, SupportedPlatform platform, Boolean isTrusted, Boolean isSupported)
   à Microsoft.SSMA.Framework.Generic.Utilities.OdbcDriverUtilities.GetDriverInformationFromList(RegistryKey registryKey, String path, List`1 filteredDriverNames, SupportedPlatform platform, Boolean isSupportedDriver)
   à Microsoft.SSMA.Framework.Generic.Utilities.OdbcDriverUtilities.GetDriverList()
   à Microsoft.SSMA.Framework.Generic.Utilities.OdbcDriverUtilities.GetDrivers(String driver)
   à Microsoft.SSMA.GUI.Generic.Controller.MySql.Dialogs.ConnectMySqlForm.get_OdbcProviders()
   à Microsoft.SSMA.GUI.Generic.Controller.MySql.Dialogs.ConnectMySqlForm.ShowForm(String& outSettings, SecureString& password, String headerText, ConnectionRequirementReason reason)
   à Microsoft.SSMA.GUI.Product.MySqlToMsSql.MySql2MsSql.ConnectToSource(String typeOperation, ConnectionRequirementReason useCase)
   à System.EventHandler.Invoke(Object sender, EventArgs e)
   à System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   à System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   à System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   à System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   à System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   à System.Windows.Forms.Control.WndProc(Message& m)
   à System.Windows.Forms.ToolStrip.WndProc(Message& m)
   à System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Assemblys chargés **************
mscorlib
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.5456 (Win7SP1GDR.050727-5400)
    CodeBase : file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
SSMAforMySql
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/SSMAforMySql.exe
----------------------------------------
mscorlib.resources
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.5456 (Win7SP1GDR.050727-5400)
    CodeBase : file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
Microsoft.SSMA.GUI.Components.Controls
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.GUI.Components.Controls.DLL
----------------------------------------
System.Windows.Forms
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.5460 (Win7SP1GDR.050727-5400)
    CodeBase : file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.5456 (Win7SP1GDR.050727-5400)
    CodeBase : file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.5462 (Win7SP1GDR.050727-5400)
    CodeBase : file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.SSMA.GUI.Product.MainProductWindow
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.GUI.Product.MainProductWindow.DLL
----------------------------------------
Microsoft.SSMA.GUI.Generic.AbstractGui
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.GUI.Generic.AbstractGui.DLL
----------------------------------------
Microsoft.SSMA.Framework.Generic.XTree
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.Generic.XTree.DLL
----------------------------------------
Microsoft.SSMA.Framework.Generic.StandardWatsonReport
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.Generic.StandardWatsonReport.DLL
----------------------------------------
Microsoft.SSMA.GUI.UIUtils.CommandLine
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.GUI.UIUtils.CommandLine.DLL
----------------------------------------
Microsoft.SSMA.Framework.MySql.SqlServer
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.MySql.SqlServer.DLL
----------------------------------------
Microsoft.SSMA.Framework.Generic.SSMAEnvironment
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.Generic.SSMAEnvironment.DLL
----------------------------------------
Microsoft.SSMA.Framework.Generic.Factories
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.Generic.Factories.DLL
----------------------------------------
Microsoft.SSMA.GUI.Product.SourceToTarget
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.GUI.Product.SourceToTarget.DLL
----------------------------------------
Microsoft.SSMA.GUI.Generic.LowLevel
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.GUI.Generic.LowLevel.DLL
----------------------------------------
Microsoft.SSMA.GUI.Components.MenuAndToolbar
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.GUI.Components.MenuAndToolbar.DLL
----------------------------------------
MS.ErrorReporting
    Version de l'assembly : 2.1.0.0
    Version Win32 :
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/MS.ErrorReporting.DLL
----------------------------------------
Microsoft.SSMA.Framework.Generic.Utilities
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.Generic.Utilities.DLL
----------------------------------------
Microsoft.SSMA.GUI.Components.MessageBox
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.GUI.Components.MessageBox.DLL
----------------------------------------
Microsoft.SSMA.Framework.MySql.Base
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.MySql.Base.DLL
----------------------------------------
Microsoft.SSMA.Framework.SqlServer.Generic
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.SqlServer.Generic.DLL
----------------------------------------
Microsoft.SSMA.Framework.Generic.SqlBase.Default
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.Generic.SqlBase.Default.DLL
----------------------------------------
System.Data
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase : file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Microsoft.SSMA.Framework.MySql.Generic
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.MySql.Generic.DLL
----------------------------------------
System.Xml
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase : file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.SSMA.Framework.Generic.Converters.Default
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.Generic.Converters.Default.DLL
----------------------------------------
Microsoft.SSMA.Framework.Generic.Synchronizers.Default
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.Generic.Synchronizers.Default.DLL
----------------------------------------
Microsoft.SSMA.Framework.Generic.DataMigrators.Default
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.Generic.DataMigrators.Default.DLL
----------------------------------------
Microsoft.SSMA.Framework.Generic.DefaultDataMigrationUtils
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.Generic.DefaultDataMigrationUtils.DLL
----------------------------------------
Microsoft.SSMA.Framework.SqlServer.Any2SqlServerGeneric
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.SqlServer.Any2SqlServerGeneric.DLL
----------------------------------------
Microsoft.SSMA.Framework.Generic.TreeConverters.Default
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.Generic.TreeConverters.Default.DLL
----------------------------------------
Microsoft.SSMA.GUI.Generic.Controller.ControllerMsSql
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.GUI.Generic.Controller.ControllerMsSql.DLL
----------------------------------------
Microsoft.SSMA.GUI.Generic.Gui.Controller
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.GUI.Generic.Gui.Controller.DLL
----------------------------------------
Microsoft.SSMA.GUI.Generic.Controller.ControllerMySql
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.GUI.Generic.Controller.ControllerMySql.DLL
----------------------------------------
System.Design
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.5460 (Win7SP1GDR.050727-5400)
    CodeBase : file:///C:/Windows/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
Accessibility
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase : file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Configuration
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase : file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
Microsoft.SSMA.Framework.MySql.Constants
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.MySql.Constants.DLL
----------------------------------------
Microsoft.SSMA.Framework.MySql.SqlServer.DataMigration.Utils
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.MySql.SqlServer.DataMigration.Utils.DLL
----------------------------------------
System.Windows.Forms.resources
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase : file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_fr_b77a5c561934e089/System.Windows.Forms.resources.dll
----------------------------------------
Microsoft.SSMA.Framework.Generic.SqlConstants
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.Generic.SqlConstants.DLL
----------------------------------------
Microsoft.SSMA.Framework.Generic.Constants
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.Generic.Constants.DLL
----------------------------------------
Microsoft.SSMA.Framework.SqlServer.Constants
    Version de l'assembly : 5.2.0.0
    Version Win32 : 5.2.1258.0
    CodeBase : file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20MySQL/bin/Microsoft.SSMA.Framework.SqlServer.Constants.DLL
----------------------------------------

Donc c'est impossible de se connecter à MySQL.
Ai-je oublié d'installer quelque chose, est-ce un bug ?
Quelqu'un aurait il déjà rencontré ce problème ?
Comment le résoudre ?

merci
Vincent

vendredi 9 novembre 2012 08:24

Réponse

|

Citation