Re: OLAP Linked query - 8k limit
- From: Prasad <Prasad@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 1 Sep 2008 18:31:01 -0700
I checked the MSOLAP properties & the 'In Process' option is enabled. I'm not
sure if there is any thing else we can do to overcome the 8k limit.
Thanks,
Venkat.
"Pascal Deliot" wrote:
IN or OUT of process is defined by OLEDB provider. This can be seen in.
SSMS/Server/ServerObjects/LinkedServers/Providers/MSOLAP/Properties: "Allow
In process".
You can try to enable the "Allow In Process" for the MSOLAP provider, this
can help. But you can face other issue, as MSOALP provider is not supported
by Microsoft "InProcess".
IN process an OLEDB provider is loaded into the SQL Server process and
communicate with SQL Server using memory segement.
OUT of process an OLEDB provider is loaded outside the SQL Server process
and communicate with SQL using RPC with some limitations...
Pascal
"Prasad" <Prasad@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message de
news:373408DF-E173-42CD-90D5-FF1B20F219F1@xxxxxxxxxxxxxxxx
How do i check this? InProcess.
Is this has anything to do the 8k limit for the OPENQUERY?
"Pascal Deliot" wrote:
Is you OLAP provider defined as "InProcess" ?
Pascal
"Prasad" <Prasad@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message de
news:707C0DC9-EE31-4301-9B58-9A71348D2689@xxxxxxxxxxxxxxxx
We are using the Linked query to execute MDX statements but are having
issue
with 8k size limit of the statement.
Did any body have a work around for these so that we can pass bigger
MDX
statements?
Thanks,
Venkat.
- Prev by Date: building a hierarchy from one-to-many relation chip
- Next by Date: Querys very slow using the function mdx YTD ()
- Previous by thread: building a hierarchy from one-to-many relation chip
- Next by thread: Querys very slow using the function mdx YTD ()
- Index(es):
Relevant Pages
|
