BUG: OLAP Provider Reports OLE DB Version as 1.5 (273597)

The information in this article applies to:

Microsoft SQL Server OLAP Services 7.0

This article was previously published under Q273597

BUG #: 10765 (Plato7x)

SYMPTOMS

The Microsoft OLAP Provider reports the OLE DB Version as 1.5 when the version should read 2.0.

STATUS

Microsoft has confirmed that this is a problem in SQL Server OLAP Services version 7.0.
This is not an issue in Microsoft SQL Server 2000 Analysis Services.

MORE INFORMATION

Steps to Reproduce Problem

To reproduce the problem, install the OLAP Services 7.0 client and server, and then run the following code in a Microsoft Visual Basic application:
```
Dim cnn As New ADODB.Connection

cnn.Provider = "msolap"
cnn.Open "Data Source=serverName;Provider=msolap;Initial Catalog =FoodMart;"
```
Look at the OLE DB Version property for the connection object in the Microsoft Visual Basic Watch window. Right-click the Watch window to display the context menu, and then add a watch. Type the following in the Add Watch dialog box
```
cnn.Properties("OLE DB Version").Value
```
which then displays:
"OLE DB Version" 1.5
You can also add this line of code to your application:
```
    Debug.Print cnn.Properties("OLE DB Version").Value
```

Modification Type:	Major	Last Reviewed:	10/3/2003
Keywords:	kbbug kbnofix KB273597

©2003 Microsoft Corporation. All rights reserved.