DirectQueryMode connection string doesn't work via OLEDB - by GregGalloway

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
1
Sign in
to vote
ID 684128 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 8/14/2011 3:22:13 PM
Access Restriction Public

Description

I have a database working in DirectQueryWithInMemory mode. I'm able to connect an MDX window in SSMS and specify DirectQueryMode=InMemory in the additional connection string properties. Then when I run a DAX query it doesn't execute DirectQuery SQL but rather answers from VertiPaq.

I would have expected that to be able to use this database from Excel, I would have to put DirectQueryMode=InMemory on the connection string. However, when I do that, I get a non-specific connection error in Excel. In order to get a more specific error message, I wrote a C# app that opened an OLEDB connection. See below for the error message I get.
Sign in to post a comment.
Posted by Microsoft on 8/29/2011 at 4:25 PM
Thanks for your report. This bug is fixed, and it will be available in the next release.

Thanks,