Pdoh's Q&A profile

• SQL Server How to determine Count of ties in MDX?

  I need to determine the number of values in a set that are non-unique in the set. In SQL, I would do the following: select sum(value_count) as Ties from (select value, count(*) as value_count from source group by value having count(*) >1 ) In MDX, I have a set defined in a query that is passed into several custom statistical functions. I would like to be able to accomplish this without writing anothe ...Show All

• SQL Server COPY DATABASE WIZARD

  Hello, I have been trying to use the Copy Database wizard, once I get through all the steps of defining the databases to use and hit finish (using SMO transfer), I get an 'Copy Database : No such interface supported' Error and the action terminates! How can I fix this Regards I am assuming you are copying both from and to SQL 2005 based databases Not sure if Copy DB Wizard will support DMO for the older sql2000 servers. ...Show All

• Visual C# XML CODE

  if you look at the code below you will see that it writes to a xml file. However it will over write a file and NOT append. I need it to append. How do i do this private void Setxmlfile() { XmlTextWriter xw = new XmlTextWriter (filename, System.Text. Encoding .UTF8); xw.Formatting = Formatting .Indented; xw.WriteProcessingInstruction( "xml" , "version='1.0' encoding='UTF-8'" ); xw.WriteStartElemen ...Show All

• SQL Server Set Report for Snapshot History via Web Service?

  Hello, Part of our Reporting Services 2005 implementation calls for the creation of a report (RDL) and uploading it to our RS server for deployment, all done programmatically.  We'd like to have the uploaded report set up for snapshot history.  Does anyone know how to do this programmatically through the web service   I know how to do it manually through Report Manager, but can't seem to find the right method calls to do i ...Show All

• Visual Studio 2008 (Pre-release) XAML Futures

  Is that possible to produce something like a main logo at: http://www.relate-software.com/uk/ using XAML I mean the shape itself and 3D effects as well Thanks. You could model a 3D shape like that shown. The rendering in WPF would be true 3D not the mock 3D shown. So the lighting would be more accurate in WPF, but require more hardware to perform well. For a single logo on a page it may not matter m ...Show All

• .NET Development System.TypeInitialization exception.

  Hi, I have a windows form application that works well in my computer in debug and release modes from IDE and windows explorer.  I do XCOPY deployment on other computer.  When I run the applicaiton there, it gives System.TypeInitialization exception. As expected, this exception is thrown when I call a class with only public static variables...no constructors, propterties and methods. How can I solve this issue   Please help me T ...Show All

• Visual Studio Express Editions System.Drawing.Graphics

  There you can draw rectangles, arcs, polygon, bezier,.... I tried all methods "draw", But i can't draw a single pixel. How do i How did you try it Your form has a Paint handler, which you can override.  The PaintEventArgs contains a Graphics object.  This is the object you need to use to draw onto your window. ...Show All

• Visual C# Incorrect File Tab Insertion

  I am using Visual C# 2005 Express Edition and when in the text editor when I open a new file it puts the tab in the tab group on the left-hand side. How can I change this so it puts the tab on the right-hand side, just like it does in 2003 or even like the task bar, which when you run a new program it adds it on the right-hand side My regional settings are English (United Kingdom) and all of them are the de ...Show All

• Visual Basic Logoff/logon windows, change user, app still running

  Just need to check if user exists in any of my given groups, like "App_Admin", "App_user" and so on. If he doesn't exist I set the max of restrictions and I set the windows loged on username, otherwise I show his username and set the restrictions according the users group. If he logs off I also set the max of restrictions with windows loged on username. I start app with the max restrictions and with windows l ...Show All

• Visual C++ error LNK2005: "void __cdecl bp5(void)" (?bp5@@YAXXZ) already defined in test.obj

  Hi All, I generated a simple SDI skeleton using the wizard, and tried to #include some of my libraries. It gave me a bunch of 'LNK2005: ... already defined ' errors. I repeated the basic SDI generation in another project and this time only tried to include a single, trivial header file: mytest.h #pragma once //#include "stdafx.h" void bp5(){  int a = 0;  a+=1; } I include this file in the testDoc.h file of my test p ...Show All

• Visual Studio Express Editions C++/SDK fails to link empty app

  I've installed Visual C++ express and the SDK as per instructions - everything makes sens, but when i try to do the last stage of the SDK set up - build an empty app - I get link errors such as: test1.obj : error LNK2019: unresolved external symbol __imp__DispatchMessageW@4 referenced in function _wWinMain@16 All paths look ok in the paths setup, i've tried both the GUI way of putting the SDK paths in and editing the file as well - everyt ...Show All

• Visual Studio Dynamically determining link type

  I'm just getting started with what may become a fairly complex DSL.  Assume I have a bunch of elements in my domain model, with a variety of link types.  In the designer, I'd like to be able to drag a "generic" link between two shapes, then have it dynamically turn into the appropriate link type (assuming there is a valid link).  If there's no valid link type between the two shapes, there should be a visual indication during the d ...Show All

• Visual Studio Team System After cancelling installation of ATDT server, what do I delete to reinstall?

  I cancelled installation of ATDT server install and installation rolled back. Before I try to reinstall ATDT server install, I had to manually delete all 6 DBs in SQL 2005. I believe rolling back installation doesn't clean up registries or leave something uncleared, which might cause installation to fail. Is there any other step I need to do (delete something other than Yukon dbs) before I reinstall server Please anyone~ ...Show All

• Visual Studio Problems opening an MSBuild Project file in VS Beta 2

  Hello I am finding that the beta 2 is unable to open an existing msbuild project file in the editor.  Previously it would just open and be recognised as a form of XML file in the text editor.  Now when I double click on the file in the solution list it draws the tab on the editing pane, with the correct name on it, but does not display the file.  The redraw process for the screen area for the file stops. I can still switch to oth ...Show All

• Visual Basic how can I 'emergency close' a form during form_load if a try/catch exception is encountered?

  Hi Does anyone know why the following does not work I'm using Visual Studio 2005. Basically I need to be able to perform an  'emergency stop'  and close a form during it'ss Form_Load event if a try /catch exception is encountered while connecting to and querying a mysql (or other) database. The example code below shows the form_load event calling the sub load_manufacturers() - I have marked the lines which do not work as expected wi ...Show All