Airan's Q&A profile

• SQL Server mdx questions

  I'm going to start reading through the performance document, but in the mean time any suggestions on how to speed up the following with member Measures.bucket1 AS sum ( filter (([REL TURN HRS].[REL TURN HRS].[REL TURN HRS]. members * [Measures].[FACT CUT RELEASE Count] ) ,[REL TURN HRS].[REL TURN HRS]. membervalue < 6),[Measures].[FACT CUT RELEASE Count]), NON_EMPTY_BEHAVIOR = { [FACT CUT RELEASE Count] } SELECT NON EMPTY { [Measures].bucket1} ON COLUMNS , NON EMPTY { ([CUSTOMER JOB].[Cust-Title-Issue-Job].[JOB_NUMBER]. ALLMEMBERS ) } ON ROWS FROM ( SELECT ( { [CUSTOMER JOB].[CUSTOMER NAME].&[T016]&[TIME4 MEDIA, INC. (T016)] } ) ON COLUMNS FROM [DW INSIGHT]) WHERE ( [CUSTOME ...Show All

• Visual Studio Team System CTP7 BUG - Database Role Membership is not Compared

  I have created a custom database Role with grants and denies in the securables and one Role Member. When I do a schema compare the role membership is not considered regardless of the settings of the IDE (schema settings, project settings). When updates are written the role is created and the grants and denies are written (the latter if ignore permissions is not checked). HOWEVER - 1. The membership is never written meaning the user is stranded without a role membership. I assume that the SQL for this should appear in the RoleMemberships.sql but it doesn't. AFAIK there are no UI Settings that affect this behaviour (ignore permissions on or off has no affect). 2. The SSMS UI view of the role does not show the securables or the schem ...Show All

• Visual Basic Error - retrieving the COM class factory for component with CLSID

  Hello, My application deals with third party objects (FileNet IDM desktop 3.3) I am trying to instantiate a third party object as new in VB.Net Dim objPropDescs as new idmObjects.PropertyDescriptions which is suppose to return a collection object, however, i receive the following error: Retrieving the COM class factory for component with CLSID {BFD54EE1-5285-11D0-B200-0020AF398F15} failed due to the following error: 80040154." it is important to note that similar code works just fine in VB6 Any thoughts, suggestions or ideas would be appreciated. Thanks rnamro, P/Invoke the COM component in the .NET Framework needs you provide the dll file correctly. When you compile the C ...Show All

• Visual Studio 2008 (Pre-release) focus rectangle on a viewport in wpf

  hi, i want to know if there exists a method to draw a focus rectangle on a viewport in wpf If no, how can i manage to do this thanks in advance, Pascal hi, you may try to use a grid to draw a rectangle on it... that is what i'm trying to do. i'll let you know if it works. Pascal ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA framework for non C#

  One of the great advantages of the .NET framework is that developers can work on the same project in different programming languages. As I'm reading about XNA, it seems that this will not be possible with the XNA framework. Will the only programming language that has access to the XNA framework be C# When you say C++/CLI, you mean the pure CLR mode Will C++/CLI mixing managed and native code work with XNA or not I can't imagine that they would allow you to distribute any unsafe, non-managed code. That sort of defeats the purpose, it seems. This is probably one of the major reasons that DirectPhysics is being implemented (just a guess). With the addition of physics, you will have managed control over all aspects of the game ...Show All

• SQL Server Run SP from remote computer needs db_owner privileges ?

  Hi All, I created SP and enabled db_datareader and db_datawriter for roles for BUILTIN\Users on database level. I can call that SP from my application if I am accessing DB from my app running on the same machine. If I run app on other machine SP throw exception related to lack of permission. I fixed that by enabling db_owner roles for BUILTIN\Users. But it is not good fix from security point of view. My question is: is there any other way to allow regular user to run that SP by not giving him db_owner privileges Also I have to mention that my SP procedure has some dynamic SQL code . I would greatly appreciate any help, Thanks, Roman It is unclear in your description if you granted execute p ...Show All

• Visual Studio Team System Labels in TFS

  Hello guys, I have a question about work with labels in TFS. How can I see all changesets between two labels Cheers, Hello, The question was raised several times. You might want to view the following thread . It discusses the changeset delta between label and the latest files version, but that should be easily adaptable to the case with two labels comparison. Regards, Eugene ...Show All

• Visual Studio Express Editions SortedList Strange Behaviour

  Or maybe, just a strange coder The code is below. I have put two mark in where you should break. Also a Stop before where the problem appears. This code does run. If you iterate thru the breaks, you can see that the Tmp variable has the correct value at each iteration. The key is also correct. and the SortedList (Temp1, Temp2) show correct values at each break. But ... When I attempt to iterate thru the SortLists using For Each, every value returned is THE LAST VALUE inserted into the SortedList. This might be the last value entered in Temp1 or Temp2 (depending on which was the last one added). That is: both SortedLists seem to be pointing their 'value' to the same place in memory ( ) The keys are returned ok. It is just the ...Show All

• Visual Studio 2008 (Pre-release) What version to report SDK RC1 faults against ?

  HI, I've been pointed to the connect site 212 for reporting faults against WPF. I'm on the RC1 SDK but this does not appear to be a version against which I can report faults https://connect.microsoft.com/feedback/CreateFeedbackForm.aspx FeedbackFormConfigurationID=734&FeedbackType=1&SiteID=212 -- Dan ...Show All

• Visual Studio Express Editions One or more errors encountered while loading the designer!!

  One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. The type 'ClientApplication02._ClientDB_Baisic_IIDataSet' has no field named 'DataSetName'. Hide Edit at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.Error(IDesignerSerializationManager manager, String exceptionText, String helpLink) at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializeAssignStatement(IDesignerSerializationManager manager, CodeAssignStatement statement) at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializeStatement(IDesignerSerializ ...Show All

• Smart Device Development Problems with more then 5 CE devices connecting to a webservice

  we made a program in .net 2005 for a windows CE device. It uses a webservice to read and write information in a database. Everything works well, till the moment we start working with more then 4 devices. With 4 it works sometimes but with 5 or more after some minutes all devices stop working. They can't connect to the webservice anymore. Does anyone has an idea what could be the reason. Because we need to be able to work with 10 devices. thanks, Bart we don't get any error only if more then 10 connections are open. No potential deadlock. This is the code in the webservice Dim ta_klant As New dsKlantTableAdapters.TA_Klant Try Return ta_klant.GetKlantInfo(tva, tel, name, customerno, zipcode) ...Show All

• Windows Forms Catching keypressed

  I have a windows Form (in a mobile device) with a button and some other controls. I want that whenever a user press the ENTER key, the button handler method is launched. I added a KeyPress event to the Form, but this is used only if the Form has the focus. If the focus is in a textBox, the keyPress event is not used! AFAIK CF doesn't support AcceptButton. You can also set your form's KeyPreview property to True and KeyPress event should be raised regardless of the focused control. Andrej ...Show All

• Smart Device Development Invoking Beep on Pocket PC using C#

  Hi, Am developing an application where i have to alert a Beep sound in a Intermec 700 series pocket pc built on Windows mobile 2003 OS. However i get a missing method exception at runtime saying "Can't find PInvoke Dll kernel32.dll". I tried using the playsound function as well. However i get some other dll cannot be invoked at runtime. I am pasting the code sample here Beep function [ DllImport ( "Kernel32.dll" )] [ return : MarshalAs ( UnmanagedType .Bool)] public static extern Boolean Beep( UInt32 frequency, UInt32 duration); Beep(750,300) PlaySound function [DllImport("winmm.dll", SetLastError = true, CallingConvention = CallingConvention.Winapi)] ...Show All

• SQL Server Browsing cubes through interfaces other than the BI Studio?

  I've built a cube, deployed it and processed it. I can use the brower in the BI Studio to see the data subsets and can manipulate it. How do I get this cube to the user without having to install BI Studios on their computer Basically how do I get the cube into IIS so the user can just open a web browser and go to it Similar to how cognos does it with their cubes. Or is this not possible I see no way to view the cube unless you are using the BI Studio to open it. Am I missing something Take a look at this one: http://www.beyond2020.com/products/vista_overview.php For a demo: http://www.beyond2020.com/products/demo.php ...Show All

• Visual Studio 2008 (Pre-release) How to make window rotation in WPF?

  How to make window rotation in WPF Help me! Just create your own chrome, make border less window and apply rotate transformation to your chrome. Other thing that you can try to explain more,in this way this will be easely to suggest you something less abstract. ...Show All