BUG: Sample Code VBADOSimple on SQL Server 7.0 CD has Error (238032)


The information in this article applies to:

  • Microsoft SQL Server OLAP Services 7.0
This article was previously published under Q238032
BUG #: 2046 (plato7x)

SYMPTOMS

VBADOSimple is a code sample that is on the SQL Server 7.0 CD-ROM. The sample code is contained in a self-extracting zip file named Samples.exe located in the \Msolap\Samples folder. If you execute this sample application, you see the following error message:
The following Error has occurred: Cannot open cube 'Sales'.

CAUSE

The line of code that is causing the error is: 
cat.ActiveConnection = "Data Source=" & strServer & ";Provider=msolap;"
The ActiveConnection property of the Catalog object should also specify the initial catalog as the "Foodmart" database in the string.

WORKAROUND

The preceding line of code should be changed as follows: 
cat.ActiveConnection = "Data Source=" & strServer & ";Provider=msolap; initial catalog=foodmart"

STATUS

Microsoft has confirmed that this is a problem in SQL Server OLAP Services version 7.0.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbpending KB238032
©2003 Microsoft Corporation. All rights reserved.