Carsten-S's Q&A profile

• SQL Server Having 2 CALCULATE statements no longer works after installing SP2!!!

  I received the following email from a collegue of mine:   I think we may have found an issue with SQL SERVER 2005 SP2   1. Some of the Analysis Services Properties when you click the advanced tab are missing!   2. The MDX scrip behaviour is not the same. In our cubes we had two CALCULATE statements - first to aggregate the data as normal, then some code to calculate MTD and YTD figures and then another CALCULATE statement. This enabled us to calculate percentages later on in the script without having to sum up all the data at leaf levels first.   With SP2, this no longer works!!! All our percentages are now being added up (like all other measures) which is clearly ...Show All

• Visual Studio Express Editions display data from sql in messagebox

  hi,got a question regarding the messagebox what i'm doing currently is displaying data from a table in a listbox using data binding source and adapter what i want to do next is to enable myself to select a particular data from the listbox,press another button to view the rest of the info from database where the attribute = selected value in a messagebox i'll give an illustration if my explanation isnt clear.i have a listbox which displays only car number plates,and i want to be able to select a particular number plate,click on another button which opens up a messagebox that displays the rest of the details of the owner of that selected license plate number is it possible to do this hi ahmedily ...Show All

• Visual Studio LaunchDebugTarget always claims file does not exist

  Hi I'm using the latest VSIP SDK packages (Sept 06) and attempting to reach first base in a project to launch and talk to a number of DebugEngines simultaneously. First base is somewhat unambitious: just launch a program with an attached DebugEngine. I've copied "hello.exe" to C:\ just to make sure it's nothing daft like spaces in filenames that causes the problems. Essentially, I always get a file not found error from the return of the LaunchDebugTargets. Any suggestions as to what fundamental bit I'm not getting CComPtr<IVsUIShell> spUiShell; HRESULT hr = pisp->QueryService(SID_SVsUIShell, IID_IVsUIShell, ( void **) &spUiShell); CComPtr<IVsDebugger> dbgr; hr = pisp->QueryService(SID_ ...Show All

• Visual Basic Build error (The type or namespace name could not be found

  I am using VS.Net 2003. I have a solution that contains 4 projects. The first project contains the definitions of interfaces. The third project is using the interfaces defined in the first project. For the third project, I added a reference to the first project. But I'm still getting a build error: c:\inetpub\wwwroot\Remoting2Project3\WebForm1.aspx.cs(28): The type or namespace name 'IAuthenticateUserService' could not be found (are you missing a using directive or an assembly reference ). Thanks in advance, Elizabeth Bradley ------------------------------------------------------------------- Interfaces.cs (in the first project named remoting2project1) using System; namespace Remoting2Project1 { /// &l ...Show All

• Visual C++ hiding LNK warnings

  Basically, I want to get rid off all the LNK warning For ex, LNK4099, or LNK4204, or any other one. I am linking my debug lib with a third party release lib. That's why I am getting those. Is there some kind of "pragma" for the linking step to hide warnings There was the undocumented #pragma comment(linker, "/ignore:4099") but it does not work anymore on Visual Studio 7.1. I is annoying to look at hundreds of these warnings rolling down on my screen. Thank you. If I add /ignore:4099 to the "additional options" of project properties->linker->command line, I still get the warnings LNK4099 I am using: Microsoft Visual C++ .NET MS Development Environment 2003 Version ...Show All

• Smart Device Development Start menu appearing when switching forms

  Hi, When I switch forms in my VB application the Start Menu and/or titlebar flicker on the screen for a brief moment, despite me having the WindowState property set to 'Maximised'. Is there any way to prevent this please Thanks, Robert Polding The University of Sheffield See David Wrighton's post in this thread . ...Show All

• SQL Server Deleting Older rows in the table

  Hi, I have a table which has around 50,000 rows. Can I delete the rows older than one year If no, Can I delete the last 25,000 rows (older rows) from the table Can you assist me with the SQL Statement to do this Thanks Santhosh If your table has an identity column you may want to delete the lowest identity values so that you can count a certain amount of records... But the best solution is to have a datetime column that keeps track of the creation time. ...Show All

• Visual C# Any good material for creating graphics?

  I need to create graphics as simple X-Y plane. The X axis is time and the Y axis is data received form some COM Port of the computer. There are several channels, so there should be several graphics. All the graphics need to be displayed both on one window and in separate windows for each. (Just like the PDF file, you can read one page at one time and you can also see tow or four pages) Besides, the data received should write to one file as .txt or Excel file. All information should be saved in one file for comparing. And the file name should automatically with the date and time. Well, is there any good examples about this I searched online, and find the free class library ZedGraph for 2-D graphics for visual studio. Or is the ...Show All

• Smart Device Development Making SmartDevice Applications with Visual Studio 2005 Express Edition

  Is it possible, to build SmartDevice applications running on Pocket PC 2003 with the Express Edition of Visual Studio 2005 (vb, vsc or vc) There is no model for smartdevice in the IDE of the Express Edition Thanks for a procedure and a list of tools/framework to have been installed No, it's not possible. VS 2005 SE or above required for device development. ...Show All

• Visual Studio 2008 (Pre-release) VisualBrush with a background and a non stretched textblock. How?

  Hello Im trying to create a custom brush, which would display some non stretched text (the actual text wont be changing on runtime), uniform background and a 1 pixel thick border (not around the text, but around the whole space being filled with that brush) Im not sure if that can be done with VisualBrush only, but here is what Im trying: <VisualBrush Stretch="Fill" AlignmentX="Left" AlignmentY="Top"> <VisualBrush.Visual> <Border BorderThickness="1" BorderBrush="Black"> <Border.Background> <VisualBrush Stretch="None" AlignmentX="Left" AlignmentY="Top"> <VisualBrush.Visual> <TextBlock>LtArea</TextBlock> </VisualBrush.Visual> </VisualBrush> </Border.Backgr ...Show All

• Visual Studio registration of COM dlls fails in dynamic clearcase views

    Hi all, we have a problem, since we migrated from VS2003 to VS2005. Our project contains several COM DLLs, but the registration of these DLLs fail with the error message: error PRJ0019: A tool returned an error code from "Performing registration"   Registration on the command line also doesn't work. Our build runs in a dynamic clearcase view. When I copy the build output to local harddisk, then registration succeeds. It also works, if I use a snapshot view, but our build process requires a dynamic view. When I build the DLLs using VS2003, there's no problem registering them in a dynamic view. The account that I use is member of the group administrators, so I don't think that this can be an access ...Show All

• .NET Development typeloadexception when using a function from DLL-file

  Hi, I use some functions from a DLL-file but I keep getting this error when I use one of these functions. Could not load type 'WindowsApplication1.k8062' from assembly 'WindowsApplication1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' because the method 'SetData' has no implementation (no RVA). The code I use to load functions from the DLL-file: using System.Runtime.InteropServices; namespace WindowsApplication1 { class k8062 { [ DllImport ( "K8062D.dll" )] public static extern void StartDevice(); public static extern void SetData( long Channel, long Data); public static extern void SetChannelCount( long Count); public static extern void S ...Show All

• .NET Development COMException (ThrowExceptionForHR) => handle is invalid when calling Marshal.FreeHGlobal

  Hello In my application, i read and write a lot from pointers (System.IntPtr). Somewhere at a "Marshal.FreeHGlobal()" (i've got a lot of them, and it varies where the program stops) i get this Exception: "System.Runtime.InteropServices.COMException (0x80070006): The handle is invalid. at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode) at System.Runtime.InteropServices.Marshal.FreeHGlobal(IntPtr hglobal) at BTR2_DLL_Test.Form1.Button11_Click(Object sender, EventArgs e) in C:\DEV_OLD\VS2003\Testjes\BTR2_DLL_Test\BTR2_DLL_Test\Form1.vb:line 714" A closer look gives me the TargetSite: Thr ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. get screen resolution & FullScreen

  How do I get screen resolution of the computer Because my program will be shared between many computers, I want the program to find the resolution of the computer on wich it is running. By example, on my computer at home, the program will return the value 1024 and the value 768 in order to make 1024 X 768. On my laptop, I will get 1920 and 1200. I want to get the width and the height separately, in two variables. With those values, I will be able to set automatically on each computer the window size as I want it. To resume, I am looking for something like this: width = computer.ScreenResolution.width; height = computer.ScreenResolution.height; Also... If I ever decide to start the game in FullScreen (Make the wind ...Show All

• Smart Device Development How to get a list of all categories

  Hi, I want to get a list of all Ctegories but cannot find anything about retrieving this infrormation. Has any one an Idea on how to do this in Pocket PC 2003 using POOM On WM2003 you would have to use the CEDB APIs directly. Open the object store volume and the database called "\Categories" then enumerate the rows present. On WM5.0 you can get them through POOM. Get the IItem interface for the required folder (e.g. Contacts) and get the PIMPR_FOLDER_CATEGORIES property. This will return a list of all the categories present for those items. Peter ...Show All