Dorisdvu's Q&A profile
SQL Server Reference axis(2) members in MDX
Hello everybody. I've got a little problem: I want to reference axis(2) members in a calculated member, so I can use multiple selection. I've tried: with member [Measures].[Test] as 'settostr(axis(2))' select {[Measures].[Test]} on 0, {[Dim Sales Territory].[Sales Territory Region]. members } on 1 from [Adventure Works DW] where ([Dim Geography].[Country Region Code].&[US], [Dim Geography].[Country Region Code].&[CA] ) However, I get an error. Is there any other way Thanks a lot, Santi You could use the Existing function: >> with member [Measures].[Test] as settostr ( Existing [Geography].[Country].[Country]. Members ) select {[Measures].[Test]} ...Show All
Visual Studio 2008 (Pre-release) Databind Child Object
Hi, I have an object called Product and that product as a property of type List<Photo>. Photo is an object with an URI and a few more properties. What I want to do is in the DataTemplate access the first Photo of each product. I have something like this for the other properties in the Product Object: <GridView x:Key="gridView" AllowsColumnReorder="True"> <GridViewColumn Header="Tipo de negocio" DisplayMemberBinding="{Binding Path=TypeOfBussiness}"/> <GridViewColumn Header="Tipo de imovel" DisplayMemberBinding="{Binding Path=TypeOfProduct}"/> <GridViewColumn Header="Tipologia" DisplayMemberBinding=& ...Show All
Visual Studio 2008 (Pre-release) Visual Studio Crashes When attempting to edit xaml file.
Visual studio just crashes on me as soon as I try to open my xaml file. I'm attatching it below. <Window x:Class="WinFXMManager.Window1" xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml " Title="WinFXMManager" Height="540.8" Width="796.8" Loaded="OnLoad" > <StackPanel x:Name="MainPanel"> <StackPanel.Resources> <Style x:Key="MyContainer" TargetType="{x:Type ListViewItem}"> <Setter Property="Margin" Value="0,1,0,0"/> <Setter Property="Height" Value="21"/> <S ...Show All
Visual Studio Team System Forward integrating (parent-to-child) bug fixes always causes conflicts
Hi everyone: I have the following branching scenario: BranchA - Version 1.0 of the product, currently in production, currently being maintained - Branch B - Version 1.1 of the product, currently under development (child of BranchA) Obviously, bug fixes in branch A need to be forward integrated into branch B. This works, but the scenario below is confusing, and can potentially cause devs to merge incorrectly: Branch V 1.0 into V 1.1 Make changes to code in V 1.1; file class1.cs Check in changes Make changes to code in V 1.0 (e.g. bug fix); file class1.cs Check in changes Merge V 1.0 to V 1.1; latest version Conflict window pops up => understandable, both versions of class1.cs have changed Merge the fil ...Show All
SQL Server How to schedule to run Integration Packages using SQL Agent/Job?
Hi Folks, I deploying a couple of integration packages which needs to be run sequentially. Currently, I quite puzzled how come i cannot run them as a SQL Agent job. It always fail with "Executed as user: Servername\Administrator. The package execution failed. " But if I had put import these integration packages into the SQL Server 2005 Integration Services FileSystem, it does run but i need promptly as there is a dialog requesting whether to execute the packages. Is there a way to automate the running of these packages through SQL agent. Pls help need to get it up and running asap. Thanks first. Hi Garynkill23, This could be due to the ProtectionLevel setting for the individual packages - that's my guess. By def ...Show All
Visual C++ Shared memory IPC
Dear all I would like to achive IPC through two procesess by using the shared memory aproach. I did some research but could not find an apropriate example that would describe that. There are few that are trying to talk about the efficiency but nothing that shows how to: Process A would write to shared memory Process B would detect that something is written and pick it up. and vice versa from B -> A Any help would be apreciated. Sincerely You asked the same question in Best approach for IPC... Confusion about what to use... and Windows IPC....help . You should not post the same question in two different forums. In the first one, you were told that this question is outside the scope of this forum. ...Show All
Visual Studio VSTA IDE toughly integrated into the host application
Hi, Is it possible to integrate the VSTA IDE directly into my host application just like a simple control In our product, we don't feel that opening the VSTA IDE in a separated window is really ergonomic. Thank you, Olivier The solution cannot be embedded directly in your application via a control. There are options for including the IDE within your own product. Please see the informtion available on the VSIP program at http://msdn.microsoft.com/vstudio/extend/ . -mark ...Show All
Visual Studio Team System Cannot Deploy without Column Collation in CTP6 - UPDATE
In CTP5 I was able to import and deploy using the default database collation (without column level collation). Since CTP6 every import and deploy script includes a collation definition for every char column in the script files. I do not want column level collation defined. The project properties are set to "Do not script the collation". The setting "Use the server collation" has no effect either. Is this a bug or did I mess something up I can't find anything else that would change this behaviour. Alle An update to this thread / problem: It seems that I was mistaken. The problem was / is not the deployment or update of the project. The IDE is in fact deploying without the ...Show All
Visual Studio Tools for Office Print an excel file with c# and suppress change prompt
Hey guys, I need to do a silent print with XLS file, its working fine for ordinary xls file without any formatting, however if the excel is formatted, it prints ok but while closing the excel application, it prompts user to save, which i dont like to happen, as it defeats the purpose of my application.. FYI: i am using the following code.. P.StartInfo.FileName = filename; P.StartInfo.WorkingDirectory = _DIRECTORY; P.StartInfo.CreateNoWindow = true ; //Create No Window P.StartInfo.WindowStyle = ProcessWindowStyle.Hidden; //WindowStyle---->HIDDEN P.StartInfo.Verb = "Print"; P.Start(); //Start the process P.Dispose(); // This code does the normal printing for any formats, but while closing it prompts. ...Show All
.NET Development unable to download file
below i've attached my code. if i copy and paste the url and query string into a web browser, i get in return a file with data based on the query string. i want to be able to do this without having to use a web browser. is this possible what is the next step i need to take with regards to coding any help at all would be greatly appreciated. thanks. static private bool CertificateValidationCallback(object sender, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { &n ...Show All
Visual Basic Display a tooltip when the mouse hover a specific word/phrase
Hello, I have a label with a lot of text. I want to do, that when I hover specific words/phrases it will display a tooltip with a pre-defined text. For example, if the label is written "Hello, welcome to my program. It will help you a lot.", then I want to do that if the user mousehover the word welcome it will display a tooltip with text of "Hi User", and if the mouse will hover the phrase "help you", it will display a tooltip with text of "In a lot of stuff". Thanks, Ofir. Thanks a lot... But if the label is multiline, then when I hover on the entire column of the word/phrase will cause a tooltip.. How can I make it so it will show the ...Show All
SQL Server Regarding MSsubscription_agents table...
Hi, I am using transactional replication with updatable subscriptions. I am not able to apply the snapsnot after doing schema changes. The subscriber throws the error Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. This error is thrown on the below query... select * from MSsubscription_articlecolumns where artid = 4 and agent_id = ( select id from MSsubscription_agents where update_mode > 0 and UPPER ( publisher ) = UPPER ( N 'Servername' ) and publisher_db = N 'TestTransUpdate2' and publication = N 'Test_TransUpdate2' ) The table MSsubs ...Show All
SQL Server attached in vb8 vs vb6 incompatability
I have two programs which access sql server 2005. One was written in vb6 the other in vb8 (aka vb.net 2005). vb6 works well with this connection string: Provider=SQLNCLI;Integrated Security=SSPI;Persist Security Info=False;Database=MyDbName;Data Source=.\MyServerInstanceName vb8 (in vs2005) generated the following connection string which works well in the vb8 application: Data Source=.\MyServerInstanceName;AttachDbFilename='C:\MyDbPath\MyDbName.mdf';Integrated Security=True Within their own programs each connection string works well. However, if I use one program and then the other (e.g., vb8 program then vb6), I get an error message: Unable to open the physical file "C:\MyDbPath\MyDbName.mdf". Operating system ...Show All
.NET Development included prereqisits in publishing application
I'm publishing as Visual Basic 2005 application that uses SQLexpress on a server. Does the application need .NET Framework 2.0 installed on the client machine for the application to comunicate with SQLexpress. The reason I'm asking is because My Laptop, the one I used to write the app has Visual Studio 2005 and when I run the application it connects to the serverbox that has SQLexpress and it work just fine, but when I install the app on another laptop and try to connect, I get an error "Login Error" Hi, This is not related to managed networking APIs. Please refere to http://ww.microsoft.com/communities for the appropriate forum/usergroup. Thanks ...Show All
Visual Studio Express Editions Skinning vb forms
is it possible to apply skins in vb forms by using this express software if so, how can anyone help me.. please.. thanks... ...Show All
