View Complete Post
am created a .net assembly in one machine, how do i call this assembly remotely from another machine. Can u give the sample code for this.
While using the below MDX query im facing the below error.
select security_new.StoredProcedures.security_enc(1) on 0 from EncryptedCube
Executing the query ...
Execution of the managed stored procedure security_enc failed with the following error: Microsoft::AnalysisServices::AdomdServer::AdomdException.
The System.Data.SqlTypes.SqlInt32 type cannot be converted to an MDX type.
Any one pls tel me im using Permission as unrestricted in SSAS assembly. The following query is executing but when i use Permission as Safe in SSAS assembly it is not working.
Please tell me about Safe Permission in SSAS assembly.
How to use Safe permission in SSAS assembly.
Any one pls tel me how to use the following statement in SSAS calculations
"Provider=SQLNCLI10.1;Data Source=TMDEVDWHSRV01;Integrated Security=SSPI;Initial Catalog=BankingDWHStg"
,"Exec DecryptPANKey 1")
While i use the above statement in SSAS calculated member it is showing error as
"MdxScript(Dax Data Mart) (8, 5) Parser: The syntax for 'call' is incorrect."
Or tell me how to use the above statement in SSAS Calculations or in Named query
Pls help me to solve the issue.
Any one please tell me how to create as object or attribute for the below Call statement.
Otherwise please guide me how to use the below statement in SSAS.
"Provider=SQLNCLI10.1;Data Source=DWHSRV01;Integrated Security=SSPI;Initial Catalog=Banking"
,"Exec Key 1")
We have a SSAS Cube (2008 R2) on a server, which end-users are viewing with Excel 2010’s PivotTable interface.
We now want to stop end-users dynamically from drilling down to sensitive data.
Specifically, we want to dynamically block the return of any pivot table in which any element has a count of less than k (and ideally: an error to
be displayed ‘query results would return sensitive data – please modify your query’)
This feature should be implemented on the server-side cube not at the level individual
end-user's Excel (e.g., Excel add-in).
I've created a CLR Analysis Server assembly that uses the ADOMD Client DLL. When I import the Assembly into my AS Server I don't receive any errors. But when I attempt to call the assembly I receive a #Error as the return. Hovering over the error it says
that it can't find the Microsoft.AnalysisServices.AdomdClient.
When I try to add the ADOMD Client DLL, I get "The main assembly has the same public key as the components installed by SQL Server Setup, you cannot use it as the main file in a CLR Assembly Object. (Microsoft.AnalysisServices)"
So looks like a Catch 22 to me. What am I missing? If AS detects that the assembly already exists in the server, why doesn't it simply use the one that is installed instead of throwing the 2nd error stating that I can't import it either???
Clearly I am missing something in my interpretation of the error, has anyone ever seen this before and how can I get around the problem???
Hi! Can someone tell me how I can troubleshoot the
following error: "Encountered multiple versions of the same assembly
with GUID...try pre-importing one of these assemblies".
The website developed in VS 2010 (.Net 3.5). This error is only received on my
workstation. Another person developing the site does not experience
this issue at all. Also, not sure if this matters, but on my workstation the 'Assembly
Information...' dialog contains no values even though the 'AssemblyInfo.vb' file does specify values for the title, desc, etc.
The GUID being referenced in the error is the main project of the three projects
within the solution.
I tried looking through the GAC, but do not see any references to the projects or DLLs in the VS solution and am not sure what else/where to look.
If I delete the copy of the solution on my local machine and pull down a copy from source control (AnkhSVN) the solution will build with no error. Once I make any changes, such as adding a new aspx file, then the error is received.
I can provide any additional information needed.
This is frustrating, and I don't know how to solve it.
I have a strange problem. I am adding a LinqDatasource object, and set the context:
protected void LinqDataSource_ContextCreating(object sender, LinqDataSourceContextEventArgs e)
e.ObjectInstance = new KaruselaDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
Then I get this error:The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=184.108.40.206, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
On web.config I already have this:<add assembly="System.Data.Linq, Version=220.127.116.11, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
NOTE: The datacontext is in a different project (DLL proect) where I added a refernce to System.Data.Linq.
is there another way adding a refernce to a web project? or only though teh web.config?
I added refernece MySql.Data to my project. My web.config looks like that:
<?xml version="1.0"?><configuration> <connectionStrings> </connectionStrings> <system.web> <compilation> <assemblies> <add assembly="MySql.Data, Version=18.104.22.168, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/> </assemblies> </compilation></system.web></configuration>
But when in ServerExplorer I try "Add Connection..." I can't find "MySql Database" in the "Choose Data Source" dialog box?
What the problem can be?
I have created a simple ASP.net Web Application (2.0) and have added a web user control.
Now in my page I have added this control but I have registered like this,
<%@ Register Assembly="WebApplication1" Namespace="WebApplication1" TagPrefix="Custom" %>
Which means I want to access all the controls in my current Web Application project
Then I have added my user control like this,
<Custom:MyUserControl ID="MyUserControl1" runat="server" PublicProperty="Hello" />
Every thing is fine but when I execute the project, NO control on my user control gets "instantiated" and thus I receive error "Object Reference Not Set"
Note that My Control has,
1) Public property PublicProperty as String
2) 1 Label control
In Load Event Handler I am setting Text property of Label Control to PublicProperty. Here object reference NOT set error occurs (which means Label control is NOT initialized).
I don't want to register my control using Src, TagPrefix etc. Any ideas?
I have the following projects in a solution :
- A Web Application
- A Class Library
- A Web Deployment project
The Web Application compiles and run fine when I don't go through the Web Deployment Project. However when I try to use that, I get the following error:
"An error occurred creating the configuration section handler for hibernate-configuration: Could not load file or assembly 'NHibernate' or one of its dependencies. The system cannot find the file specified. (F:\Folke\Folke.csproj_deploy\Release\web.config line 4)"
This is the beginning of my Web.config:
<? CLR Inside Out: Migrating an APTCA Assembly to the .NET Framework 4 The CLR security model in the Microsoft .NET Framework 4 has undergone some substantial changes, including the adoption of "Level2" transparency, similar to the Silverlight security model. Mike Rousos provides an in-depth explanation of how that will likely impact authors of AllowPartiallyTrustedCallers (APTCA) libraries.Mike RousosMSDN Magazine March 2010
The CLR security model in the Microsoft .NET Framework 4 has undergone some substantial changes, including the adoption of "Level2" transparency, similar to the Silverlight security model. Mike Rousos provides an in-depth explanation of how that will likely impact authors of AllowPartiallyTrustedCallers (APTCA) libraries.
MSDN Magazine March 2010