We have a Com Add-In for Excel as part of our product, used by thousands, that has caused havoc since Version 1707 arrived, begining with build 8326.2058 and still a problem with build 8326.2087
We have used this code untouched for a few years without fail, and works thru build 8229.2103 (last build of Version 1706)
For now a rollback satisfies customers, but it prevents anybody from using our demo product, as we can find no workaround.
In short we declare/load/change variables to contain sql statements which change upon user choices, etc. and run thru a connection string "OLEDB;DSN=QQubeUser"
When we now run this command: oInteropPivotTableCache.Refresh()
We get this error:
System.Reflection.TargetInvocationException occurred HResult=-2146232828 Message=Exception has been thrown by the target of an invocation. Source=mscorlib StackTrace: at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object args, Boolean byrefModifiers, Int32 culture, String namedParameters) at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object providedArgs, ParameterModifier modifiers, CultureInfo culture, String namedParams) InnerException: HResult=-2147467261 Message=Attempted to read or write protected memory. This is often an indication that other memory is corrupt. InnerException: System.AccessViolationException occurred HResult=-2147467261 Message=Attempted to read or write protected memory. This is often an indication that other memory is corrupt. Source=mscorlib StackTrace: at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32 aWrapperTypes, MessageData& msgData) InnerException:
Can you please advise on what we can do to get this bug fixed? This is is very painful for our business, and the second bug affecting our business in the last several months. (and yes we just survived Hurrican Harvey in Houston).