FIX: Error Occurs when you Exit Internet Explorer or Excel When You Use a Pivot Table Control with a Visual Basic User Defined Function

Article translations Article translations
Article ID: 291265 - View products that this article applies to.
This article was previously published under Q291265
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 2109 (plato7x)
Expand all | Collapse all

On This Page

SYMPTOMS

If you use a Microsoft Visual Basic User Defined Function in a calculated member, and then the calculated member is used in a Pivot Table control in either Microsoft Excel or Microsoft Internet Explorer, an "Application Error" may occur when you exit Microsoft Excel or Internet Explorer.

RESOLUTION

SQL Server 2000 (Analysis Services)

To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

WORKAROUND

Use the Msvbvm60.dll (version 6.0.88.77) Visual Basic run-time file in Visual Studio 6.0 Service Pack 4 (SP4).

You can download Microsoft Visual Studio 6.0 SP4 from the following Microsoft Web site at:

http://msdn2.microsoft.com/en-us/vstudio/Aa718353.aspx

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

SQL Server 2000 (Analysis Services)

This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.

MORE INFORMATION

You can extend the list of built-in functions by creating libraries of functions using the Component Object Model (COM) in Microsoft Visual Basic. You can register these libraries and use your functions in calculated member definitions and other expressions written in Multi-dimensional Expressions (MDX).

REFERENCES

For more information about the use of external functions with Microsoft Analysis Services, see the "Registered Function Libraries" topic in SQL Server Books Online.

Properties

Article ID: 291265 - Last Review: February 27, 2014 - Revision: 4.2
APPLIES TO
  • Microsoft SQL Server OLAP Services
Keywords: 
kbnosurvey kbarchive kbbug kbfix kbsqlserv2000sp1fix kbssas800sp1fix KB291265

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com