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.

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


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.