I'm using Toad Data Point 3.3. I just upgraded my workstation to Windows 7 from XP. Prior to the upgrade, I was able to export results to Excel with no issues. Since the upgrade it's a no go.
Here is the error i'm getting:
Here is the log file info:
10:23:35 AM Thread (15) Export Started [3/11/2014 10:23:35 AM]
10:23:35 AM Thread (15) Export using connection: E1 PD GL (mrs43757p)
10:23:35 AM Thread (15) Export using connection: E1 PD GL (mrs43757p)
10:23:35 AM Thread (15) Export Wizard: Building object list
10:23:35 AM Thread (15) Exporting Data (1 of 1)
10:23:35 AM Thread (15) Object Table Result Set started.
10:23:36 AM Thread (15) Object Table Result Set finished with error: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)).
10:23:36 AM Thread (15) at System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(RuntimeType objectType)
at System.Runtime.Remoting.Activation.ActivationServices.CreateInstance(RuntimeType serverType)
at System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(RuntimeType serverType, Object props, Boolean bNewObj)
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache)
at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object args, CultureInfo culture, Object activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object args, CultureInfo culture, Object activationAttributes)
at System.Reflection.Assembly.CreateInstance(String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object args, CultureInfo culture, Object activationAttributes)
at Quest.Toad.ImportExport.Writers.WriterExcelInstance.InitializeExcelApp()
at Quest.Toad.ImportExport.Writers.WriterExcelInstance.InitializeExcelPIA()
at Quest.Toad.ImportExport.Writers.WriterExcelInstance.WriteHeader(Object tableObject)
at Quest.Toad.ImportExport.ExportObjectData.StartTableWrite(Object context)
at Quest.Toad.ImportExport.ExportObjectData.Begin(LogEventHandler logEventHandler, Dictionary`2 connections, Object context)
10:24:07 AM Thread (15) Export Finished [3/11/2014 10:24:07 AM]
Any idea on how to get this functionality back?
Thanks,
Mike Smith