FIX: OLAP Manager may return error after you install MDAC 2.6

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

SYMPTOMS

After you install Microsoft Data Access Components (MDAC) version 2.6, and you try to copy and paste an OLAP object from OLAP Manager or use the Cube/Dimension Editor to add a new object, you may receive the following error message:
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

CAUSE

Because the SQL Server driver that ships with MDAC 2.6 is more restrictive, this error occurs when objects are saved and read from the repository. This only occurs if the OLAP repository is migrated to SQL Server.

WORKAROUND

To work around this problem, you can roll back to an earlier version of MDAC. For more information about the Rollback feature, see the "Frequently asked questions about the installation of Microsoft Data Access Components (MDAC)" article on the following Microsoft Web site:
http://support.microsoft.com/kb/842193/en-us

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in SQL Server OLAP Services 7.0 Service Pack 3. For more information, contact your primary support provider.

RESOLUTION

To resolve this problem, obtain the latest service pack for SQL Server OLAP Services 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
301511 How to obtain the latest SQL Server 7.0 service pack

Properties

Article ID: 275867 - Last Review: February 28, 2014 - Revision: 5.2
APPLIES TO
  • Microsoft SQL Server OLAP Services
  • Microsoft Data Access Components 2.6
Keywords: 
kbnosurvey kbarchive kbbug kbfix kbolap700sp3fix KB275867

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