dbTalk Databases Forums  

Openquery fails on Windows Server 2003

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Openquery fails on Windows Server 2003 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steve Hughes
 
Posts: n/a

Default Openquery fails on Windows Server 2003 - 05-04-2005 , 04:27 PM






I have a query that only returns part of the values from an openquery
statement using MDX. It creates calculated members using the WITH statement
and these members are members of the MEASURES dimension.

The entire query works fine running on SQL Server 2000 Dev SP3a on Win XP.

However, on two installs of SQL Server 2000 Std SP3a on Windows Server 2003
only part of the data gets returned. The remaining data comes back as
integer nulls.

Any help would be greatly appreciated as we are trying to move this to
production shortly and I am having no luck with what is wrong.

Thanks.
Steve Hughes
steve.hughes (AT) xata (DOT) com

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.