.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

OLAP Query failures using an ADOMD Connection

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :ASP.Net

Hello world,

I have a live working website (ASP.NET 3.5) that pulls data from an OLAP cube on a remote server without any problems. However I now need to move the website to a different web server, and for reasons unknown I cannot get the OLAP queries to work in the new location.

I have installed the same versions of .NET Framework (3.5) and ADOMD.NET (8.0) on both servers, and the website pages were copied across servers with no changes made, so this can't be a coding issue. However I get errors like the following when the new site tries to query the OLAP cube:

: Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: 
	OLAP server error: Formula error (syntax error: invalid token: line 1, position 53, token: "&").
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular(CommandBehavior behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
   at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader(CommandBehavior behavior)
   at BaseClass.run_olap_query(String MDXquery, AdomdConnection conn)

(Note: run_olap_query is my method that attempts to run the query).

The error would suggest

View Complete Post

More Related Resource Links

Adomd.net "A Connection Cannot be Made , Ensure that the server is running"

Hi I am connecting to my local cube from vb.net windows forms application. This form is called several times within my application. While in the application, i close the form and reopen it frequently.  The conAdomd.Open() functions without any error for the first three times . As in , when i launch the windows forms application for the third time, i get an error "A connection cannot be made, Please ensure that the server is running". I have tried installing the patches, but it does'nt help me.  Request help from forum members. Dim conAdomd As New AdomdConnection() conAdomd.ConnectionString = String.Format("Provider=MSOLAP.3;Data Source={0};", filename)     conAdomd.Open()

Query to the data connection or webservice

Dear Infopath Gurus, I am facing a problem while fetching data from a (web-based) Infopath form library, as a secondary data source. Background: I have connected text-boxes on the form with a form library (secondary source), these text boxes are suppose to fetch values from the associated columns (dynamic in nature) and display it on the web form. But whenever I reopen the form, these text boxes do not fetch or display the updated values in the columns. The temporary solution that I applied was, applying a rule (Query using a data connection) whenever a form opens/loads. This solution was bringing the updated values alright but as the number of forms in the form library increased, a form was taking more than a minute to load. Which is totally unacceptable at user end. I also tried to apply a similar rule (Query using a data connection) to the text boxes on the form but for some unknown reason its not fetching the updated values from the form library. I am carefully putting an easy condition to trigger the last mentioned rule but its not giving the required result. Problem: Despite associated/connected with the secondary source columns, the form is not fetching the updated values on its own If I associate a (data query) rule whenever the form opens or loads, it takes ages to load If I associate a (data query) rule with the text boxes instead it

Connect Analysis Server across network using ADOMD connection



I'm new to Analysis Server. How will i connect the Remote Analysis Server across Network using ADOMD Connection.


Please Help me!


Imagemap connection to database query



I have an imagemap that works: 

Protected Sub ImageMap1_Click(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ImageMapEventArgs) Handles ImageMap1.Click
Select Case (e.PostBackValue)
Case ("Dublin")
Label1.Text =

"You selected " & e.PostBackValue
Case ("Cork")
Label1.Text =

"You selected " & e.PostBackValue
Case ("Southern")
Label1.Text =

"You selected " & e.PostBackValue
Case Else
Label1.Text =

"You did not click a valid hot spot region."
End Select

All the postback values are correct. Instead of sending the postback value to a label I want to use this in a select statement with a database. How do I achieve this? The output should be sent to a gridview.

Many thanks.

How to connect OLAP data source WITHOUT using http connection


Hello Guys,

I used to connect my OLAP database with this connection strings :

"Data Source=http://<target IP>/olap/msmdpump.dll;Catalog=<cube name>;Impersonation Level=Anonymous;"


but somehow, it managed to be disconnected for some other reason... 

then, i try to not using HTTP connection...

""Data Source=<target IP>;Catalog=<cube name>;Impersonation Level=Anonymous;"


the result is, I cannot connect to my OLAP.. 

Any suggestion? I want to connect my OLAP without using HTTP connection...



Best Regards and Thanks,

Roland Andreas

Query/Connection/Connect unavailable after "a transport-level error has occurred"


In SSMS for SQL Server 2008, when I leave a connection open overnight to a remote server, I occasionally get disconnected.  This is OK, and it's not the issue.  I know there are several reasons that can cause this, such as the remote server could have been rebooted.

The problem is that once this happens, under the Query menu item, in the Connection sub-item, the Connect item is greyed out -- so I can't try to reconnect in the same window.  I also have a Connect icon on the toolbar, and it is greyed out also.  This query window is now dead. 

If I open a new query window, I can connect with no problem, but I have to copy any temporary SQL code I was working with from the now-useless original query window, into the new one.

Why would the Connect item become permanently unavailable?  SQL 2005 didn't do this.  I have installed the latest CU on SQL Server client tools (SSMS says the client tools are at 10.0.4270.0).  Client is on Windows 7 Pro x64.

Thanks for any info.

How to customize/assign a keyboard shortcut to Sql query analyzer 2005 to Query-> Connection-> Chang



 How do I customize/assign a keyboard shortcut to Sql query analyzer 2005 to Query-> Connection-> Change Connection Option. I want to assign a shortcut say, Ctl+1 or Ctl + ~ which should popup the window for changing connection.

  i tried the shortcuts menu in tools option but it only lets you execute a storedprocedure on certain predifined shortcut combinations. how do I get my above desire satisfied?

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

How to Encrypt Query String Parameters in ASP.NET

Encrypt Query String Parameters in ASP.NET.u can send secure data one page another page u can also use query string to encrypt

Content Query Web Part missing in SharePoint 2010

If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

SQL Connection String

We can learn or know how can we connect the database from our .net. This will help for freshers or .NET beginners!

abstract away the source of the connection string using a class with a static property.

ASP.NET provides a configuration system we can use to keep our applications flexible at runtime. In this article we will examine some tips and best practices for using the configuration system for the best results.

The element of a web.config file is a place to store connection strings, server names, file paths, and other miscellaneous settings needed by an application to perform work. The items inside appSettings are items that need to be configurable depending upon the environment, for instance, any database connection strings will change as you move your application from a testing and staging server into production.

Let's abstract away the source of the connection string using a class with a static property.

connection string question from a newbie


when publishing  in the webmatrix dialogue it asks for "destination connection string" for my "database.mdf"

I was not sure what it was so I pasted this from my web.config file :

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True

it all published ok, but wont run, so I guess it has somthing to do with this connection string or some kind of configuration issue.

My question is this, What should go in the field for "Destination connection string"

localhost is not set up to establish a connection on port 51624 with this computer


I'm trying to run asp.net locally, but getting the error

localhost is not set up to establish a connection on port 51624 with this computer

How can I fix it?

sql query that don't run



I'm going crazy... i've got a piece of code that don't update the database... Could somebody tel me why it doesn't run??

Dim conn As SqlConnection
        Dim cmd As SqlCommand
        Dim cmdstring As String = "Update Corsi Set [Contenuto]='" & TxtText.Content & "' Where [ID]='" & Request.QueryString("Id").Replace("'", "") & "'"
        conn = New SqlConnection(SqlAnni.ConnectionString)
        cmd = New SqlCommand(cmdstring, conn)

Need help with a linq to sql query


I want to display some stats in a listview contril.  The table contains a record for every impression and for every click, and every record has a datetime field for the time and date of the impression of click.  I want to be able to display how many impressions and clicks there were in a given day and hour, something like below:

Date              Time                              Impressions    Clicks
8/20/2010                                               450              14            
                     Midnight -1:00am               150               5

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.


I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend