ADO.NET :: OLAP Query Failures Using An ADOMD Connection?
Oct 27, 2010
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:
[Code]....
(Note: run_olap_query is my method that attempts to run the query). The error would there is a mistake in the syntax of the MDX query, however that is definitively not the case. I have retrieved the MDX that the page attempted to run at the error reporting stage and have run it manually in Analysis Services - it returns results with no complaints. The same MDX queries are also still running quite happily on the original website.The only notable difference I can spot between the servers is that the original server has SQL Server 2000 installed and the new server has no version of SQL Server, but I would not expect the site to need SQL Server on the local machine to run these queries. Does anyone know if this is the case? I'm somewhat stumped as to what the cause of the issue is here, and am completely out of ideas as to where to look.
P.S. Here is my code, though I do not think it will be relevant:
[Code]....
View 4 Replies
Similar Messages:
Mar 19, 2010
I am new to using ADOMD for accessing SSAS cubes. I am having an issue with concurrency. I am using ADOMD to connect to SSAS 2005 in an ASP.Net 2008 application. When a user executes an MDX query and the ASP.net page opens an ADOMD connection, a second user that tries to execute an MDX query gets "a connection is already open" error. I don't understand how ADOMD works. Does it open only one connection for all users because ASP.Net is using a single account for all connections from the web server? I do not have this problem when using ADO.net in the same manner.
View 2 Replies
May 16, 2010
I am new to ASP.NET MVC and using ASP.NET MVC 2 with XVal. I am not using DataAnnotationsModelValidatorProvider and instead using NHibernateValidatorNHibernateValidator attributes. I would like to know that, when failing to provide a value for a non nullable type, how can i override the vanilla messages.There are actually two scenarios for non nullable type with model binding failure
1) when the data the user entered isn't compatible with the data type (for example, typing in "abc" for an integer field). The default message for this is: "The value [AttemptedValue] is not valid for [Property]."
2) when the user did not enter any data for a field which is not nullable (for example, an integer field). The default message for this is: "A value is required."
I know that the [Required] validator from DataAnnotationsModelValidatorProvider is treated specially during model binding failures on non-nullable types, so that you're not stuck with the vanilla message 'A value is required.'.
Also The DefaultModelBinder uses [Required] attribute for the second scenario only.Since I am not using DataAnnotationsModelValidatorProvider, I can not use [Required].Bearing in mind that I am already doing all the attribute validation and other business rules validation in my domain layer using XVal , What are my options here?
- Allow the model binding validation errors to occur, and then ignore and remove them from ModelState in my action method and refill it with my custom validation errors?
- Derive a custom model binder from and defaultmodel binder and override the onModeUpdated method ignoring all the validation?
View 2 Replies
Oct 4, 2010
I am fairly new to the asp.net scene. Having build a dashboard gathering info on my OLAP system's health status, I can't seem to figure out how to make sure that I catch the no connection exception.I use the following statements on the datagrid:a) want to change the color of ssas2 button to red if an exception is throw
MyDBConn.ConnectionString =
"Provider=MSOLAP.4;Data Source=core-ssas2;Integrated Security=SSPI;Initial Catalog=Financials;Connect Timeout=6000"
MyDBConn.Open()
MyDBConn.CreateCommand.CommandTimeout = 120
View 1 Replies
May 31, 2010
I want to use from two db connection in one linq query
My sample is:
int a=1;
if(a==1)
DataClasses1DataContext1 db = new DataClasses1DataContext1();
else
DataClasses1DataContext2 db = new DataClasses1DataContext2();
var q =
from c
in db.F_Groups
select c;
In this code a=1 so db connection is DataClasses1DataContext1
I want if a=2 then db connection = DataClasses1DataContext2
but this code is error.
db connections is completely same but in two deferent class a db connection is sql and another is oracle
View 4 Replies
Mar 18, 2010
I am able to dynamily bind my grid to the cube based off the facillity I have selected. Now, if a facility has multiple cubes, I want the users to switch between the two cubes dynamicly, so I have created a drop down list showing their cubes and the ones that they can select. Currently I'm been trying several things in order to "rebind" the data but they don't seem to be working, so I figured I would attach my code to see if anyone Had a good idea.
If I make the cube change then switch back over to change facility and then back to the page, the new cube will load. So I have to find a way to do it in the one step rather then have them navigate to another page and then back again. Perhaps auto navigate them to a page and have that page send them back etc... Anyway here is the code: I first bind the data via the page_prerender call
[Code]....
Then the code drops down into the LoadCube(FacilityID) sub routine
[Code]....
Then here is the setup for the subroutine that will call the page load/ should change the cube to the correct cube.
[Code]....
View 1 Replies
Oct 4, 2010
I am fairly new to the asp.net scene. Having build a dashboard gathering info on my OLAP system's health status, I can't seem to figure out how to make sure that I catch the no connection exception.use the following statements on the datagrid:a) want to change the color of ssas2 button to red if an exception is thrown
View 5 Replies
Jun 13, 2010
it will be very interesting that controls for input in forms have another property ie semanticid semanticname so semantically can be relationate i.e textboxes content if then we retrieve the data using linq having olap cubes we could have a lot of diferent views comunicating diferent controls of diferent webparts that shares the same semantically set or point to same ontology for the several dates or same localization from different input forms collection data,etc.
View 3 Replies
Jun 21, 2010
I have designed a gridview one of the fields of which I want to send the user to an URL onclick. After browsing the net for a while, I opted for converting the BoundField to a TemplateField. The same OLAP metric ([Measures].[GP]) works fine in the bound field yet produces an error in the Template:
<asp:TemplateField
HeaderText="GP Var">
<HeaderStyle
Font-Names="Verdana"
Font-Size="Smaller"
HorizontalAlign="Center"
[code]...
View 10 Replies
Jun 23, 2010
I am having problem in diffrentitate error between internet connection loss error and Other Error in query for example: duplicate record found.
Both the error fall into System.Data.SqlClient.SqlException category.
But the way to handle both this 2 error is different.For connection error , i need to bring user to connection loss page while for duplicate record found error, i need to show the user a pop up.
Unless i do a checking exactly on the error message , else i have no ways to differentiate connection loss error and any other error. Am i correct for this?
View 1 Replies
Sep 10, 2010
How do we convert, the following code to query a SQL database with ASP using a DSN-less connection
[Code]....
View 2 Replies
Dec 9, 2010
how to present a .cube created in BI Development Studio as part of a .aspx page? Windows Server 2008 hosting the site using IIS 7. The SQL server and the management studio and the BI Development Studio used to create the .cube are on the same windows server. Am using Visual Studio 2010 Premium to develop for .NET Framework Verison 4. Using an impersonation account to control access to the db.
View 1 Replies
Sep 13, 2010
I'm using Visual Studio 2008, and my database is SQL Server 2000.
I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.
But when I click OK, I get the error:
Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.
View 3 Replies
Mar 15, 2011
just for my testing purpose i know i can define both the connection's outside in a single web config file by different name's and access them in my front end according to it but what if i want to have seprate for both connection's web.config situation is like this see image so i want to access my connections from second web config file how i can do that.
[Code]...
i tired this but its giving error
[Code]....
View 1 Replies
Jun 5, 2010
I previously used a datasource and a connection string to connect to my database on sql server and all orked fine. The connection string was saved in my web.config file and is: ....
View 1 Replies
Jul 23, 2010
I am using VS2008 and oracle 10g ODP.Net. The oracle database that I used in the connection is working and tested it using sql plus.The connection string when used in a GriDView works perfectly. Now when I created a new listview control with the same connection it gives an error.Database schema could not be retrieved for this connection. Please make sure connection settings are correct and the database is online
Object reference not set to an instance of an object at VSDataObjectSupport (478,6)
View 2 Replies
Apr 7, 2010
In my DAL i have more than 100 methods/Function, each and every method am opening the sqlconnection and closing the connection, this is taking too much of time to establish the connection at every time. So what i expect is one common class will create the SqlConnection that will check if the connection is Broken or Closed then create the connection again else return the connection, how to do this(Also i would like to apply ConnectionPooling).
View 7 Replies
Jul 4, 2013
In my application there are 4 connection strings...from that i want one connectionstring should be default connection string.How to do ?
View 1 Replies
Sep 30, 2010
I have VS 2010 professional. I am trying to open "ASP.Net Configuration" through Project -> ASP.Net Configuration.
It pops up the Notification about the ASP.Net Development Server localhost but doesn't open ASP.Net Configuration in the default browser.I clicked on the Root Url (by double clicking on the 'development server' at the right bottom from Notification Manager).
It throws following error
"An error was encountered. Please return to the previous page and try again."
Clicking on "How do i use this tool".It opened page with error.
Tool Has Timed Out
View 2 Replies
Oct 18, 2010
I am preparing for an Access2007 db conversion at the beginning of the year and would like to know what the best process would be for connecting to the sqlserver2005 database. I have read about adding the connection string to the web.config file. I have also read about using ADO.NET and put the connection information into a class and not the web.config file.
I would like to hear from others as to what you have used, are using, or plan on using for a webapp (vs2010), and why so I can get an understanding.
View 3 Replies
May 31, 2010
I am new in Asp.net with Oracle and not build proper connection in it.
View 2 Replies
Aug 10, 2011
I have an ASP.Net website running on IIS7. The Application Pool is set to ASPv4 Classic.
Authentication Mode is set to ASP.Net Authentication & Windows Authentication
My question is, when I want to connect to SQL using a "trusted connection" in the Connection String, what user will actually be passed into SQL?
I thought it would pass my logon details, but it is coming back with an NT AUTHORITYANONYMOUS LOGON error, which seems to point towards it not passing in my logon.
View 8 Replies
Apr 18, 2010
When I open an ASP.NET 3.5 project using VWD2010, I get a prompt error message,"The connection property in the web.config file is missing or incorrect.The connection string from the .dbml file has been used in its place."however, my project works successfully.
View 1 Replies
Mar 12, 2013
I have got ssl security for my website.I have written onLoad that [URL] ... Should redirect on [URL] ... it redirects but first the [URL] ....pages loads full and then after a sec it redirects...I want to solve this
function(){
windows.onload = windows.location.href("https://mylifeshades.com")
}
View 1 Replies
Feb 16, 2010
I'm trying to implement a bit of functionality that will behave much like the CustomError pages: if the connection is remote function A() will run; else function B() will run. The only problem I'm having is that I'm not sure the best way to determine a "remote" connection. Does it matter if I'm running my code on a shared web host? Can I rely on just comparing "my" IP to the request's IP?
View 1 Replies
