Article ID: 275867
Article Last Modified on 5/18/2006
APPLIES TO
- Microsoft SQL Server OLAP Services
- Microsoft Data Access Components 2.6
This article was previously published under Q275867
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:
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
Additional query words: Microsoft Data Access Components SQL Server Driver
Keywords: kbbug kbfix kbolap700sp3fix KB275867