MySQL Bugs: #94569: Not able to create server connections

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:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S1 (Critical)
Version:	1.3.7	OS:	Windows (10)
Assigned to:		CPU Architecture:	Any

Description:
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:
?

Screen shot of the issue

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

second screen shot showing other tab

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

Creating a new connection Windows 10 Pro and Excel Office 365

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

Selecting the connection with connection list

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

Thank you for the bug report. I couldn't repeat on similar environment than yours. Try a remove and reinstall it.

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.

My Excel Version 1901 Build 11231.20174 64-bits.

That could be the difference then since my version is 1808.

Has someone tried this with Exccel verrsion 1808? I would like to be able to use this software.

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
Excel
Version: 1808
Build: 10730.20280

MySQLForExcelInterop.log

MySQLForExcel Information: 1 : MySQL for Excel Startup
    DateTime=2019-04-15T16:46:12.9624765Z
    Timestamp=3153155802
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)
    DateTime=2019-04-15T16:47:46.3958600Z
    Timestamp=3408009901
    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
    DateTime=2019-04-15T16:47:48.9163507Z
    Timestamp=3414886021

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.