BUG: VBDSOWriteEnableCube: Debug Assertion Caused by a Data Type Not Addressed in the Sample Code

• Microsoft SQL Server OLAP Services version 7.0

SYMPTOMS

You may encounter the following error when you try to run the sample code VBDSOWriteEnableCube:

Cannot create writeback table. [Microsoft] [ODBC Microsoft Access Driver] Syntax error near field definition.

CAUSE

The preceding error occurs because the code does not address the case for the adBigInt datatype in the GetColumnTypeDefinition function.

WORKAROUND

Insert an additional case in the SELECT statement in GetColumnTypeDefinition():

Case adBigInt
            GetColumnTypeDefinition = " BIGINT " 

STATUS

Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0.

MORE INFORMATION

You will encounter this error only if you are trying to write enable a cube that has a measure of datatype Big Integer (for example "Sales Count" in the Sales cube of FoodMart database).

Also, this sample is designed for Jet provider. You may need to modify GetColumnTypeDefinition() for other providers that have different data type names.

Additional query words:

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