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

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(MouseEventAr gs 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.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(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

"Sandeep" wrote:

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