Microsoft KB Archive/238032

= BUG: Sample Code VBADOSimple on SQL Server 7.0 CD has Error =

Article ID: 238032

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



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.

Keywords: kbbug kbpending KB238032

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.