R
R Brideau
Hey all --
The issue is when I click to connect interactively to select a data
source
for the pivot table, in either VB or ASP I get the following errors...
In VB... I am able to set up a connection and test successfully,
but when it comes back to the Command and Options dialog, I get
the VSW exception filter in the devenv.exe and OWC11.dll and .NET
crashes.
In ASP... Clicking on Commands and Options results in "Unspecified
Error"
Ironically the OWC11 pivot works perfect in Excel 2003 applied to a
UserForm.
I've tried re-registering the OWC11.dll manually with the following...
regsvr32 "D:\Program Files\Common Files\Microsoft Shared\Web
Components\11\owc11.dll"
....and it reports successful.
Regarding project references, they seem to be fine; when I add the OWC
objects
to the toolbar, and add them to the form, the references are
automatically
added to the reference list properly.
I've been scouring the newsgroups & MSDN for several days now to no
avail.
Certainly someone else must have come across this?
Windows 2000 Server SP4
SQL Server 2000 SP3
Analysis Services SP3
..NET 2001
..NET Framework 1.1
Excel 2003 SP1
MDAC 2.7 SP1 Refresh
TIA
Richard
The issue is when I click to connect interactively to select a data
source
for the pivot table, in either VB or ASP I get the following errors...
In VB... I am able to set up a connection and test successfully,
but when it comes back to the Command and Options dialog, I get
the VSW exception filter in the devenv.exe and OWC11.dll and .NET
crashes.
In ASP... Clicking on Commands and Options results in "Unspecified
Error"
Ironically the OWC11 pivot works perfect in Excel 2003 applied to a
UserForm.
I've tried re-registering the OWC11.dll manually with the following...
regsvr32 "D:\Program Files\Common Files\Microsoft Shared\Web
Components\11\owc11.dll"
....and it reports successful.
Regarding project references, they seem to be fine; when I add the OWC
objects
to the toolbar, and add them to the form, the references are
automatically
added to the reference list properly.
I've been scouring the newsgroups & MSDN for several days now to no
avail.
Certainly someone else must have come across this?
Windows 2000 Server SP4
SQL Server 2000 SP3
Analysis Services SP3
..NET 2001
..NET Framework 1.1
Excel 2003 SP1
MDAC 2.7 SP1 Refresh
TIA
Richard