koolasa's Q&A profile

• SQL Server (MDX) EXISTING operator - inconsistent behaviour when using subcubes?

  I am getting what I think is inconsistent behaviour when using the EXISTING operator to obtain a set defined by the current query context... See the two queries below (explanation follows). WITH MEMBER [Measures].[MyDate] AS Tail ( EXISTING [Date].[Calendar].[Date], 1). item (0). membervalue SELECT {[Measures].[MyDate]} ON 0 FROM [Adventure Works] WHERE [Date].[Date].[October 26, 2002] ... returns [26-10-2002] WITH MEMBER [Measures].[MyDate] AS Tail ( EXISTING [Date].[Calendar].[Date], 1). item (0). membervalue SELECT {[Measures].[MyDate]} ON 0 FROM ( SELECT [Date].[Date].[Oc ...Show All

• .NET Development how to generate random xml messages

  hi all, I need to generate random XML messages out of a schema, what could be the easiest soultion dot net solution of generating .cs file first and inserting data in stream seems too complicated, also its not generic. I want a generic soultion that would let me create XML data against any XSD schema any ideas regards, Omer Have you read the article http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnxmlnet/html/xmlgen.asp  that discusses how to do this in .NET   Or is that too complicated because it involves writing code The commercial XML Schema editors offer this feature, ...Show All

• Visual Studio 2008 (Pre-release) Cannot Create WinFX Application after installing Orcas

  I just installed all the Feb CTP stuff, (WinFx, Win SDK, and ORcas extenstion for VS 2k5), and I have an error when I want to create an new WinFX Application : - "the project \documents and settings\myuser\local Settings\temp\ezaeuiaoeuaz.gun\Temp\ApplicationData1.csproj cannot be opened)." and - "The project type is not supported by this installation" Thanks for help. Which project template were you using I don't recognize the project name "ApplicationData", and I'm not sure why the project would be created in the temp folder. ...Show All

• Visual C++ lnk2019 issue

  Hi everyone,   I am new to this and would like to apologize in advance if the issue i address here has already been answered ( i did look ). I am porting over vs6.0 to vs2005 and running into problems when trying to compile. Error 13 error LNK2019: unresolved external symbol _amac_to_bmac referenced in function _smbSrcMAC smb_utils.obj  I have multiple .h files and .c files that are being included.  I don't understand why i am getting these messages. for vs6.0 it is working properly.  currently, amac_to_bmac is defined as void amac_to_bmac( char * ascii_mac, unsigned char bin_mac ...Show All

• Visual Studio Express Editions preventing thread from abort at specfic stage

  i am creating a thread that will do some work and then enter those info in database. use can abort that thread but i want to prevent that thread won't abort when it is inserting some thing in database, instead it will abort after that Why not disable/enabled the button at the appropriate times.  If the button is disabled then they cant execute the button click event code containing the thread.abort command Button1.enabled = false ...Show All

• Visual Studio Paging

  Let's say I have a middle-tier component that can page, so it has a methods like public CustomerCollection FillPage(int startRow, int maxRows) public int GetRecordCount() is there any way to tell the report the number of pages, and reload the data from the datasource depending on the page I am I found an event that get's triggered when you change the current page, but I did not find a way to tell the report the number of pages I have... Thanks No, you cannot tell ReportViewer how many pages there are. You could hide ReportViewer's toolbar and add your own toolbar to the form. Then when the user presse ...Show All

• Software Development for Windows Vista need help

  Kind of getting frustrated how to build my first workflow. The design falls into sequential workflow type. My idea of workflow is to define Manufacture, QC and Release that  the Widget in our scope has to go through to be legitimate for next use. Finishing of Release would define that the object has passed all steps. To play with workflow designer I've set up Manufacture/QC/Release as code activities, was able to create an instance of workflow but each time new one was fired up tracking database (got that running too) recorded Manufacture/QC/Release and worflow terminated. I've read writeup on EventSinks and I ...Show All

• Windows Forms DataView Sort is not working on ComboBox

  Can anybody explain what is wrong in this code:   Dim dv as DataView dv = objUserDetailsMsg.USRMASTER.DefaultView dv.Sort = "username" + " ASC" cboBox.DataSource = dv.Table cboBox.DisplayMember = "username" cboBox.ValueMember ="userid"   the combobox is not at all sorted on the basis of username colum objUserDetailsMsg is a typed dataset and USRMASTER is a tableName in the typed dataset. I believe you need to set the combo's DataSource to be the DataView, not the underlying DataTable. Good luck... ...Show All

• SQL Server create dynamic x-axis value of a bar chart

  Hello guys, I want to create OLAP report using a bar chart. The Date hierarchy of the cube will be the category field (the x-axis value). The units along the x-axis are dependent on the amount of time specified in the query, and are determined as follow: If Query period Unit will be >2 years Years 4 mos - 2 years Months 1 mos – 4 mos Week 1 day – 1 month Day < 1 day Hours How can I achieve this scenario. Any idea will be appreciated Sincerely, Amde ...Show All

• Software Development for Windows Vista SQL Persistence, Loading Workflows and Workflow Properties

  I have a workflow that has a bunch of properties on it. One of those properties is the name of the user that initiated the workflow (it is passed into the workflow via the Dictionary<string, object> class. I have SQL persistence working just fine (well, I can't figure out how to 'auto persist', so I am manually calling 'Unload' when the workflow idles), and I run through the list of workflow IDs persisted when my application starts up. What I want to do is access the properties on that workflow (they're public) once I have the instance ID. I just can't seem to find a way to access those properties. Anyone I am using the SQL ...Show All

• SQL Server Windows XP Home Edition

  According to the feature matrix for the various SQL Server 2005 editions, basic Reporting Services are available from the Express edition. However, trying to access the Report Manager proves fruitless on Windows XP Home Edition, I suspect because IIS is not available on this edition of the operating system. Can someone confirm this is the case, and if so, is there is an alternative way of accessing this feature, say for example through a configuration of Cassini Thanks in advance Stuart I can't believe ms is really going to include full blown reporting services in express edition.  However, you can emb ...Show All

• Windows Forms Can you use .NET Windows Forms in Outlook ?

  I am currently investigating COM add-ins for Outlook.  I was wondering if it was possible to program an Outlook add-in completely in .NET including Forms  Mark: You can write the code in .NET, but there will still be a COM interop layer between Outlook and .NET. That is, there's no magic. Outlook uses COM, and there has to be a& ...Show All

• Visual Studio Team System Continuos Integration example in October SDK

  I am running the beta3 refresh of Team Foundation and am trying to use the Continuos Integration example in the October Visual Studio SDK - The example is based on the July CTP so my first question is is there an equivalent beta3 example anywhere I could get hold of I am getting compilation errors when I first try and compile the example CI web service, I have managed to get it to compile by taking a guess at the differences in July and Beta3, however when I do a test checkin, a build isn't kicked off. I have followed the lab in the CI example closely so I have done the command line subscription to the checkin event etc. Is there ...Show All

• SQL Server Trouble setting-up witness.

  Not sure where I am going wrong ... I am able to set-up the mirroring , but the witness set-up always fails. I am running all the 3 SQL servers (Enterprise edition) with same domain account, which is also a member of sysadmin locally within each SQL server. When I try to add the witness on Principal using the following command: ALTER DATABASE MyDB SET WITNESS = 'TCP://WitnessServer:7022' I have even tried the IP address with port number and fully qualifying domain (TCP://WitnessServer.xx.xx.com:7022) and I get the following message in error log. 2006-06-20 10:16:55.07 spid57 The ALTER DATABASE command could not be se ...Show All

• Visual Studio Team System Buying VS2005 Team Foundation Server - need to purchase SQL 2005 separately?

  We're getting ready to purchase VS Team Edition for Software Develer, VSTeam Suite and VS2005 Team Foundation Server. I've also looked at the software requirements for VSTeam Foundation Server and see that it also requires SQL Server 2005 SE or EE. I was not sure that whether we have to purchase SQL Server 2005 separatly, so I talked to Microsoft presale. They did not answer my question directly but instead direct my to URL http://msdn2.microsoft.com/en-us/library/ms400732.aspx Then again, I called Microsoft presale to get pricing for SQL Server 2005. They suggested to I go to one of authorized volume licensing to get better deal for ...Show All