dbTalk Databases Forums  

Catching MDX Error in ASP

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


Discuss Catching MDX Error in ASP in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andrea Worley
 
Posts: n/a

Default Catching MDX Error in ASP - 01-12-2004 , 09:21 AM






I have an ASP page that displays MDX results in a formatted table. I create a cell set and then open it with code below.

***Set cst = Server.CreateObject("ADOMD.CellSet")
***cst.Open

Does anybody know of any way to catch the following error in ASP code? It occurs on the cst.Open line when the user inputs a dimension that doesn't exist.

Microsoft® OLE DB Provider for Analysis Services error '80040e14'
Formula error - cannot find dimension member ("[OrderDate].[Qtr 3 2004]") - in a name-binding function



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.