Pawel from TETA's Q&A profile

• SQL Server Parent-child hierarchy: how to get readable member unique names?

  Is it possible to have a parent-child dimension which is referenced from the fact table via an integer key but shows a string key in it's MDX unique member name Here is the background to my question: I have a dimension with a single parent child hierarchy. The key column is test_key and the parent column is test_key_parent, both of type integer. This works beautifully except for the MDX member names which are similar to "[Dim Test].[Hierarchy].&[10]". This project has a requirement that the member unique names are readable so this is not acceptable for me. My next approach was to add a couple of string columns: test_co ...Show All

• Visual C# Application settings

  hi, i want to know what's the difference between those 2 ways  in saving variables and which one is better or what's the use of each one 1) MyControl.Property = global ::MyApp.Properties. Settings .SettingName; i saw the designer use this way   can i use this way to save my variables like for example userName and password when the user check  remember me check box 2) string user = ConfigurationSettings .AppSettings[ "UserName" ]; this method give me warrning " i should use ConfigurationManager , but when i type ConfigurationManager it give me errors as if no class so called like that, also when ...Show All

• Visual C# TextBox Right-click problem

  Hi, I've got a problem with right-clicking a ListBox which doesn't seem to get triggered. I have a ListBox with a vertical scroll-bar (my list has over 2,700 entries). What I want to do is be able to right-click to select a row (as I already do with a left-click), but my context menu will pop up also (just like what happens when you right-click any file in Windows Explorer). At the moment, my context menu pops open, but the right-click doesn't highlight the row at the mouse pointer location. I have tried setting events on the TextBox for things like Click, MouseClick, MouseDown and they all work fine for the left mouse button, but w ...Show All

• SQL Server Meta Data Services SQL 2000 "msdb database could not be opened"

  Hello anyone / everyone, If you are having trouble accessing Meta Data Services on W2k3 and SQL 2000 and get the error that the "msdb database could not be opened" I found that hot fix 912812 on the operating system is the culprit. Remove it and Meta Data goes back to working, although I am being asked to approve the ActiveX control every time the page refreshes. Hope this helps somebody, to took me long enough to track it down. If anyone has a resolution to the ActiveX question I'd love to know the answer. Thank you, Uncle Davy I also removed the "Internet Explorer Enha ...Show All

• Visual Studio Express Editions Registration

  Anyone else getting endlessly repeated requests from VB 2005 Express to register   I've registered 4 times so far, and still the balloon keeps popping up in the system tray to remind me to do so. I installed from the .img CD download, and there's no option anywhere to enter a reg code.  Does someone know of a registry fix that will turn this off I also installed from an .img CD and have not seen the popup ballons. I however am unable to register the product, the web page never loads....unable to display. Is there an alternate link to register the product VB 2005 Express FYI - I'm behind a corporat ...Show All

• SQL Server error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0

  hi, i'm using SQL Server CE 2.0 in my application. When i try to synchronize my database by calling replicator.Synchronize(); errors :   Initializing SQL Server Reconciler has failed. process could not connect to Distributor SQL Server does not exists and access denied. what i did right now is i try to register regsvr32 "C:\Program Files\Microsoft SQL Server CE 2.0\Server\sscerp20.dll" regsvr32 "C:\Labs\NorthwindTempFiles\sscesa20.dll" both of the DLL files were succeed register. However, when i try to re-do the synchronization. The same error still happened!!! I do not know what's going wrong..=( Who can help m ...Show All

• SQL Server How automatically process a Cube periodically

  Good morning, I have create a solution with two cubes, but I want that these cubes process automatically, with a batch or a windows task. But I don't find how to do this. Do I need to create a script or something like that. I'm totally lost. Thanks for your help, You can use SQL Server Integration Services (search for Processing Objects Using Integration Services in BOL), or you could also Analysis Managment Objects (AMO). ...Show All

• Visual Basic Navigate Backwards and Forwards button missing

  I can't find these buttons on the Toolbar.  They were very useful in VS2003.  Where can I find them Luis C. Uribe When you first launched Visual Studio, what settings did you choose If you choosed Visual Basic, then you will see see a simplified toolbar layout that was intended to expose only the most commonly used commands. The bad news is that these commands were not considered the most commonly used commands. The good news is that you can easily modify what commands will show up on the toolbars/in your menus... In the top-level Tools menu, select Customize... Select the Commands tab in the dialog. In the list of Categori ...Show All

• Windows Forms Strange GDI leak in MDI app...

  I have an MDI application that was keeping references to its child forms.  I have diagnosed these leaks using the CLR Profiler and fixed them, however I still get GDI leaks (~12 handles) whenever I create/show/close a child window.  Even a plain instance of System.Windows.Forms.Form causes leaks.  What is even more bizarre is that the leaks do not  ...Show All

• Visual Basic Stopping Alt+Ctrl+Del

  Hi all I'm writting a program for public payable networked computers for playing games. I've got the server/client billing and other stuff like that done. Problem is, when my program boots up, it displays a full screen form (on top of everything), which holds the login/programs they can use/play. I've managed to remove the Alt+Tab, Alt+F4 and other key combinations like that.  Although, i'm finding that Alt+Ctrl+Del still brings up task manager no matter what i do. I have a solution, that on program startup, it renames taskmgr.exe, (and the backup in dllcache), and it works (Doesn't launch taskmgr),  however, there is a window ...Show All

• Visual Studio Team System Branch or second workspace?

  I have a simple problem I'm trying to solve, but I'm hung up on the workflow best practices with TFS version control. I'm accustomed to using copy project to move applications from my machine up to a web server. Now with things stored in the repository it's unclear the best way to move them (promote them) through the rest of the life-cycle. Suppose I have a new team project....I've added my solution everything works fine. I checkout some files, mod them and check back in. I've been working in my own personal workspace on c:\blah. I'm happy with my changes, but now my field testers want to test it. I need to move that exact version of the app ...Show All

• SQL Server Meta Data

  Hi, I want to get meta data information for DTS packages, I don't see anything when I click on Meta Data Services Package. Also, I get an error when I click on Meta Data "An error occurred while trying to access the database information. The msdb database could not be opened." Need help.. Thanx SQLBob Hi, SQLBob, I was having the same problem. On the assumption that you are running under Win2003 SP1 look for hot fix 912812 on the operating system. Remove it and Meta Data goes back to working. Uncle Davy ...Show All

• SQL Server SSIS Diagramming

  Hi, I just want to ask, is there a tool that can create a diagram supporting the SSIS package I have created I would like to know if there is any available tool that can do this task so that I can support my SSIS package documentation. For example, I have created a Data Flow task that transfer data from a source database to SQL server 2005 destination. I would like to create a diagram that summarizes the task it perform from source to destination automatically. My purpose is that whenever DB users check my SSIS package, they will have a concise idea of how my SSIS package works through my diagram. If ever yo ...Show All

• Visual C++ CString will not go to cout

  The code: CString foostr ("This is a string."); cout << foostr << endl; Gives the output: 0035C3B8 I've spent the last two hours doing experiments and hunting around the Internet for information on this. What's going on The memory address of the CString is being printed. cout << foostr.GetBuffer(foostr.GetLength()) << endl; foostr.ReleaseBuffer(); ...Show All

• Visual Studio er..., Site project again

  I am trying to build a site proj (a new site created by wizard) in Team Build. I have set the value of  " BuildToPlatform " to " Mixed Platforms ", <ConfigurationToBuild Include="Release|Mixed Platforms">       <FlavorToBuild>Release</FlavorToBuild>       <PlatformToBuild>Mixed Platforms</PlatformToBuild>  </ConfigurationToBuild> but I got the following msg: Build started 10/20/2005 8:51:12 PM. __________________________________________________ Project "d:\builds\aspnetsite\AspNetPrj\AspNetPrjBuild\BuildType\TFSBuild.proj" (EndToE ...Show All