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

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)
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:
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
Microsoft Data Access Components SQL Server Driver
Properties

Article ID: 275867 - Last Review: 02/28/2014 04:21:59 - Revision: 5.2

Microsoft SQL Server OLAP Services, Microsoft Data Access Components 2.6

  • kbnosurvey kbarchive kbbug kbfix kbolap700sp3fix KB275867
Feedback