Bug #94569 Not able to create server connections
Submitted: 5 Mar 2019 21:25 Modified: 18 Mar 2019 23:11
Reporter: Kyle Edwards Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL for Windows: MySQL for Excel Severity:S1 (Critical)
Version:1.3.7 OS:Windows (10)
Assigned to: CPU Architecture:Any

[5 Mar 2019 21:25] Kyle Edwards
I installed MySQL for excel version 1.3.7 on my Windows 10 computer running Office 365 (Excel Version 1808 Build 10730.20280) and when I try to add a "new connection" there are no options for hostname, port, username, password, or default schema. All I see is "MySQL Username" and "H.A. Groups Filter", which I assume are for local connections. Changing to the SSL or Advanced tabs makes no difference to what is shown. Also tried switching between TCP/IP and Local Socket, but it made no difference. Tried a re-install with no luck.

How to repeat:
Possibly related to Office 365?

Suggested fix:
[5 Mar 2019 21:25] Kyle Edwards
Screen shot of the issue

Attachment: Missing parameters.PNG (image/png, text), 115.83 KiB.

[5 Mar 2019 21:26] Kyle Edwards
second screen shot showing other tab

Attachment: Same for all three tabs.PNG (image/png, text), 102.26 KiB.

[5 Mar 2019 21:49] MySQL Verification Team
Creating a new connection Windows 10 Pro and Excel Office 365

Attachment: 94569.png (image/png, text), 131.74 KiB.

[5 Mar 2019 21:50] MySQL Verification Team
Selecting the connection with connection list

Attachment: 94569_1.png (image/png, text), 87.53 KiB.

[5 Mar 2019 22:01] MySQL Verification Team
Thank you for the bug report. I couldn't repeat on similar environment than yours. Try a remove and reinstall it.
[5 Mar 2019 22:28] Kyle Edwards
Thanks for your quick reply. I tried a few more re-installs using the standalone msi and the community installer and no luck. Your version of Excel looks different than mine,so not sure if that might be part of the issue. Is there a chance I am missing some support software that I don't know about? I don't get any errors.
[5 Mar 2019 22:55] MySQL Verification Team
My Excel Version 1901 Build 11231.20174 64-bits.
[6 Mar 2019 17:40] Kyle Edwards
That could be the difference then since my version is 1808.
[18 Mar 2019 23:11] Kyle Edwards
Has someone tried this with Exccel verrsion 1808? I would like to be able to use this software.
[16 Apr 2019 11:11] joel allen
No connections available in excel. Workbench connections work. 
Deleted settings.config, restarted excel, no joy.
Hours of development invested, no return.

Edition: Windows 10 Enterprise
Version: 1709
Build: 16299.1087

Microsoft Office 365 ProPlus
Version: 1808
Build: 10730.20280


MySQLForExcel Information: 1 : MySQL for Excel Startup
MySQLForExcel Error: 1 : Unhandled Exception
Thrown by: MySqlSourceTrace.WriteAppErrorToLog
Exception message: Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))
   at Microsoft.Office.Core._CustomTaskPane.Delete()
   at Microsoft.Office.Tools.CustomTaskPaneImpl.Dispose()
   at Microsoft.Office.Tools.CustomTaskPaneCollectionImpl.RemoveHelper(CustomTaskPaneImpl customTaskPane)
   at Microsoft.Office.Tools.CustomTaskPaneCollectionImpl.Remove(CustomTaskPane customTaskPane)
   at MySQL.ForExcel.ThisAddIn.CloseExcelPane(ExcelAddInPane excelPane)
    Callstack=   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at System.Diagnostics.TraceEventCache.get_Callstack()
   at System.Diagnostics.TraceListener.WriteFooter(TraceEventCache eventCache)
   at System.Diagnostics.TraceListener.TraceEvent(TraceEventCache eventCache, String source, TraceEventType eventType, Int32 id, String message)
   at System.Diagnostics.TraceSource.TraceEvent(TraceEventType eventType, Int32 id, String message)
   at MySql.Utility.Classes.MySql.MySqlSourceTrace.WriteToLog(String message, Boolean showErrorDialog, SourceLevels errorLevel, Int32 messageId)
   at MySql.Utility.Classes.MySql.MySqlSourceTrace.WriteAppErrorToLog(Exception exception, String errorTitle, String errorMessage, Boolean showErrorDialog, SourceLevels errorLevel, Boolean useInnerException)
   at MySql.Utility.Classes.MySql.MySqlSourceTrace.WriteAppErrorToLog(Exception exception, Boolean showErrorDialog, SourceLevels errorLevel, Boolean useInnerException)
   at MySQL.ForExcel.ThisAddIn.CloseExcelPane(ExcelAddInPane excelPane)
   at MySQL.ForExcel.ThisAddIn.Application_WindowActivate(Workbook workbook, Window window)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Delegate.DynamicInvokeImpl(Object[] args)
   at System.Runtime.InteropServices.ComEventsMethod.DelegateWrapper.Invoke(Object[] args)
   at System.Runtime.InteropServices.ComEventsMethod.Invoke(Object[] args)
   at System.Runtime.InteropServices.ComEventsSink.System.Runtime.InteropServices.NativeMethods.IDispatch.Invoke(Int32 dispid, Guid& riid, Int32 lcid, INVOKEKIND wFlags, DISPPARAMS& pDispParams, IntPtr pvarResult, IntPtr pExcepInfo, IntPtr puArgErr)
   at Microsoft.Office.Interop.Excel._Application.get_ActiveWorkbook()
   at MySQL.ForExcel.ThisAddIn.get_ActiveWorkbook()
   at MySQL.ForExcel.Controls.ExcelAddInPane.Dispose(Boolean disposing)
   at System.ComponentModel.Component.Dispose()
MySQLForExcel Information: 1 : MySQL for Excel Shutdown
[16 Apr 2019 11:20] joel allen
Failed to mention that log output was following attempted restore of data in worksheet with saved connections. Also, have since reinstalled MySQL for Excel with no change in behavior.