MySQL Forums
Forum List  »  MySQL for Excel

Error ENABLING MySQL for Excel IN Excel
Posted by: Chris Schroeder
Date: January 13, 2014 02:09PM

Hi. Installed 32 bit version of mysql for excel on 32 bit windows 7 professional. (have uninstalled this add-on, reinstalled and rebooted many times in effort to resolve issue, however I always get the same result)
Microsoft Office Professional Plus 2010
Under add/remove program files I see the MySQL to Excel installation present. It shows up as "MySQL For Excel 1.1.3" authored by Oracle Corporation.

Under COM Add-Ins inside the running Excel application, the MySQL for Excel add-in is listed as a com object. The check box next to it is clear. I put a check mark in it. I click OK. I get the following error window:

Microsoft Office Application Add-In
An unhandled exceptoin occurred in your application. Contact your administrator or the author of this document for further assistance.

Then, in the details section it says:

Log file path must be defined before calling the WriteToLog method.


************** Exception Text **************
System.Exception: Log file path must be defined before calling the WriteToLog method.
at MySQL.Utility.MySQLSourceTrace.WriteToLog(String message, SourceLevels messageType, Int32 messageId)
at MySQL.Utility.MySQLSourceTrace.WriteAppErrorToLog(Exception ex, SourceLevels messageType)
at MySQL.ForExcel.ThisAddIn.ThisAddIn_Startup(Object sender, EventArgs e)
at Microsoft.Office.Tools.AddInImpl.OnStartup()
at Microsoft.Office.Tools.AddInImpl.AddInExtensionImpl.Microsoft.Office.Tools.EntryPoint.OnStartup()
at Microsoft.Office.Tools.AddInBase.OnStartup()
at MySQL.ForExcel.ThisAddIn.FinishInitialization()
at Microsoft.Office.Tools.AddInBase.Microsoft.Office.Tools.EntryPoint.FinishInitialization()
at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.ExecutePhase(ExecutionPhases executionPhases)
at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.Microsoft.VisualStudio.Tools.Office.Runtime.Interop.IExecuteCustomization2.ExecuteEntryPoints()


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1008 (RTMGDR.030319-1000)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Microsoft.VisualStudio.Tools.Office.Runtime.Internal
Assembly Version: 10.0.0.0
Win32 Version: 10.0.31007.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime.Internal/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Runtime.Internal.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1001 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Microsoft.VisualStudio.Tools.Applications.Runtime
Assembly Version: 10.0.0.0
Win32 Version: 10.0.31007.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
Microsoft.Office.Tools
Assembly Version: 10.0.0.0
Win32 Version: 10.0.31007.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.dll
----------------------------------------
Microsoft.Office.Tools.Excel.Implementation
Assembly Version: 10.0.0.0
Win32 Version: 10.0.31007.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Excel.Implementation/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Excel.Implementation.dll
----------------------------------------
Microsoft.Office.Tools.Common.Implementation
Assembly Version: 10.0.0.0
Win32 Version: 10.0.31007.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Common.Implementation/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.Implementation.dll
----------------------------------------
Microsoft.Office.Tools.Common
Assembly Version: 10.0.0.0
Win32 Version: 10.0.31007.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Common/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.dll
----------------------------------------
Microsoft.Office.Tools.Excel
Assembly Version: 10.0.0.0
Win32 Version: 10.0.31007.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Excel/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Excel.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1002 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1001 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
MySQL.ForExcel
Assembly Version: 1.1.3.0
Win32 Version: 1.1.3
CodeBase: file:///C:/Program%20Files/MySQL/MySQL%20For%20Excel%201.1.3/MySQL.ForExcel.DLL
----------------------------------------
Microsoft.Office.Tools.Common.v4.0.Utilities
Assembly Version: 10.0.0.0
Win32 Version: 10.0.30319.1
CodeBase: file:///C:/Program%20Files/MySQL/MySQL%20For%20Excel%201.1.3/Microsoft.Office.Tools.Common.v4.0.Utilities.DLL
----------------------------------------
MySQL.Utility
Assembly Version: 2.1.0.87
Win32 Version: 2.1.0.87
CodeBase: file:///C:/Program%20Files/MySQL/MySQL%20For%20Excel%201.1.3/MySQL.Utility.DLL
----------------------------------------
MySQLWorkbench
Assembly Version: 6.0.8.11354
Win32 Version: 6.0.8.11354
CodeBase: file:///C:/Program%20Files/MySQL/MySQL%20Workbench%206.0%20CE/MySQLWorkbench.exe
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1015 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Security
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1016 (RTMGDR.030319-1000)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Security/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Security.dll
----------------------------------------



Edited 1 time(s). Last edit at 01/14/2014 06:06AM by Chris Schroeder.

Options: ReplyQuote


Subject
Views
Written By
Posted
Error ENABLING MySQL for Excel IN Excel
3278
January 13, 2014 02:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.