Bug #94569 Not able to create server connections
Submitted: 5 Mar 21:25 Modified: 18 Mar 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:Microsoft Windows (10)
Assigned to: CPU Architecture:Any

[5 Mar 21:25] Kyle Edwards
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:
?
[5 Mar 21:25] Kyle Edwards
Screen shot of the issue

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

[5 Mar 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 21:49] Miguel Solorzano
Creating a new connection Windows 10 Pro and Excel Office 365

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

[5 Mar 21:50] Miguel Solorzano
Selecting the connection with connection list

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

[5 Mar 22:01] Miguel Solorzano
Thank you for the bug report. I couldn't repeat on similar environment than yours. Try a remove and reinstall it.
[5 Mar 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 22:55] Miguel Solorzano
My Excel Version 1901 Build 11231.20174 64-bits.
[6 Mar 17:40] Kyle Edwards
That could be the difference then since my version is 1808.
[18 Mar 23:11] Kyle Edwards
Has someone tried this with Exccel verrsion 1808? I would like to be able to use this software.
[16 Apr 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
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
[16 Apr 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.