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

ID: Q238032

The information in this article applies to:

Microsoft SQL Server OLAP Services version 7.0

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 this to be a problem in SQL Server OLAP Services version 7.0.

Additional query words:

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug