Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2007

Tip: Looking for answers? Try searching our database.

Run-time error '-2146233079 (80131509)' in the Excel Application

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sandeep - 27 Jul 2007 13:50 GMT
I have created a Macros to view the Analtyical Reports in the Excel.

When the user is trying to get the data from the server he is getting an
error message though i am able to perform the operation successfully on my
env.
Error Message:
Run-time error '-2146233079 (80131509)':
The underlying connection was closed: The connection was closed unexpectedly.

As we clik on the ok button for the above error message pop-up, i am getting
an another error message with the following details.
It has two buttons defined on the pop-up:- Cancel and Continue.

Then this error message appeared:
Microsoft .NET Framework box:
Unhandled exception has occurred in a component in your application. If you
click Continue, the application will ignore this error and attempt to
continue.
Exception from HRESULT: 0x800A9C68

Please help me on this issue.

Thanks,
Sandeep
Sandeep - 27 Jul 2007 13:52 GMT
Detail desc about the error message...

Within the error box window there was a Details drop down:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Runtime.InteropServices.COMException (0x800A9C68): Exception from
HRESULT: 0x800A9C68
  at Excel._Application.Run(Object Macro, Object Arg1, Object Arg2, Object
Arg3, Object Arg4, Object Arg5, Object Arg6, Object Arg7, Object Arg8, Object
Arg9, Object Arg10, Object Arg11, Object Arg12, Object Arg13, Object Arg14,
Object Arg15, Object Arg16, Object Arg17, Object Arg18, Object Arg19, Object
Arg20, Object Arg21, Object Arg22, Object Arg23, Object Arg24, Object Arg25,
Object Arg26, Object Arg27, Object Arg28, Object Arg29, Object Arg30)
  at ExcelRender.ViewListing.NextButton_Click(Object sender, EventArgs e)
  at System.Windows.Forms.Control.OnClick(EventArgs e)
  at System.Windows.Forms.Button.OnClick(EventArgs e)
  at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
  at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks)
  at System.Windows.Forms.Control.WndProc(Message& m)
  at System.Windows.Forms.ButtonBase.WndProc(Message& m)
  at System.Windows.Forms.Button.WndProc(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.42 (RTM.050727-4200)
   CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
ExcelRender
   Assembly Version: 1.0.2742.37164
   Win32 Version: 1.0.2742.37164
   CodeBase:
file:///C:/Program%20Files/Oracle/Xml%20Publisher/Consolidation%20AddIn/ExcelRender.dll
----------------------------------------
Interop.Scripting
   Assembly Version: 1.0.0.0
   Win32 Version: 1.0.0.0
   CodeBase:
file:///C:/Program%20Files/Oracle/Xml%20Publisher/Consolidation%20AddIn/Interop.Scripting.DLL
----------------------------------------
System.Windows.Forms
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.42 (RTM.050727-4200)
   CodeBase:
file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.42 (RTM.050727-4200)
   CodeBase:
file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.42 (RTM.050727-4200)
   CodeBase:
file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Interop.Excel
   Assembly Version: 1.3.0.0
   Win32 Version: 1.3.0.0
   CodeBase:
file:///C:/Program%20Files/Oracle/Xml%20Publisher/Consolidation%20AddIn/Interop.Excel.DLL
----------------------------------------
System.Configuration
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.42 (RTM.050727-4200)
   CodeBase:
file:///C:/WINNT/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.42 (RTM.050727-4200)
   CodeBase:
file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.42 (RTM.050727-4200)
   CodeBase:
file:///C:/WINNT/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
   <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Thanks,
Sandeep

> I have created a Macros to view the Analtyical Reports in the Excel.
>
[quoted text clipped - 20 lines]
> Thanks,
> Sandeep

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.