LeoWong's Q&A profile

• SQL Server selecting date range

  I have an MDX query that I'm using in Reporting Services: SELECT NON EMPTY { [Measures].[NumberOfClaims] } ON COLUMNS FROM ( SELECT ( [Date].[DTM02_Date].&[2003-12-23T00:00:00] : [Date].[DTM02_Date].&[2005-01-01T00:00:00] ) ON COLUMNS FROM [ClaimStatus]) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS Now this works fine... until I change the dates... such us putting in 2000 instead of 2003 in the date first date. This cube is from two tables: 1. A Claim table (health care claim) 2. A Date table The data table has two columns: 1. a key 2. the actual date The claim table has a key that links to the date table's key, and the corresponding date is the claim date. So when ...Show All

• SQL Server Question on Microsoft Association Rules

  I build a data mining model to predict what are the best studying methods for the student to pass the examinaton. Create Mining Model StudentAssociation ( Student_No long key, Gender text discrete predict, PassOrFail text discrete predict, StudyMethod table predict ( MethodName text key ) ) Using Microsoft_Association_Rules ( Minimum_Support=0.02, Minimum_Probability=0.03 ) The mining table will contain all the methods that the students use, no matter their examination is passed or failed. The value of PassOrFail will have either 'Pass' or 'Fail'. According to the above model, can I query the best studying methods Or I should only train the model with the student who pass the examination, and ignore all the failed. Tha ...Show All

• SQL Server StartService() returned error 5, 'Access is denied.' - xp_servicecontrol

  Hi, I am trying to start the SQL Agent in my T-SQL code : exec xp_servicecontrol 'START' , 'SQLServerAgent' but it is giving me this error: StartService() returned error 5, 'Access is denied.' My test environment is SQL Server 2005 Developer Edition on XP Professional. I am using the same user as the one I installed the database but, not the SQL Agent's service account. I read some online info about this and there were some issues with SQL Server 2000; mostly registry permissions. I can not imagine it is still a problem for 2005. Any ideas Thank you. AE Hi, are you logged in with SLQ Server Authentication or WIndows authentication If you are using SQL Server authent ...Show All

• Visual Studio Team System Server not referred to by the FQDN

  I want the server to refer to itself ONLY by the FQDN. http://img116.imageshack.us/img116/2330/properties9sk.jpg if you have a look in the image - the server name is Fully Qualified, although the link that it will send the user to is not. how do i make them both be the same FQ thank you. The link that the server sends to the client is generally constructed based upon the prototocol and server name used to connect to the server. If you clear the TFS cache on the client and then reconnect using a FQDN, you should see that the client uses that FQDN. There are a few places where TFS uses "absolute" URLs, and if you want a complete FQDN solution, you will need to upda ...Show All

• Visual Basic how to do this???

  A. Application: Control Structures Procedures Arrays B. Program Specification: Project Name: countletters Project Type: Windows Application C. Requirement Description: Write a windows application that accepts a string as input and determines the number of occurences of each character in the string. Implement this using a form with a TextBox, a Button, and a ListBox. Please refer to the graphic file(s) associated with this Machine Problem. Use the TextBox as the data entry for the string, the Button for invoking the count process, and the ListBox for the output. Assume that the user may enter any number of printable character available in the ASCII table. Ignore the spaces and the character case if alphabetic(i.e. 'A' an ...Show All

• SQL Server Sql Server Express Terms of Use

  Hi Hopefully im asking this in the right place, sorry if its not, maybe you could point me in the right direction I have been informed that use of MDF Files (SQL Server Express) Databases on the net was restricted as this was classed as multi connections and therefore was outside the free license agreement. I am looking at commercially developing and marketing a web based system for with a relatively small database footprint (well under 1gb) with ASP.NET 2.0 and like the look of SQL Server Express. Could anyone clear up whether or not this is allowed under the SQL Server Express terms of use, or point me in the direction of somewhere i can find information. Thanks Hi, the usage in the specific scenario is ...Show All

• .NET Development WebException: The underlying connection was closed

  Hi After upgrading our win client app to run on version 2.0 of the .net framework (prev. v1.1) on of our customers reports the following error when calling a web service on our server: System.Net.WebException: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server. The customer is using a proxy-server, but it worked fine before the upgrade, and other customers who are behind proxy-servers has no problems. The error does not occur when the customer accesses the web service using Internet Explorer. The customer is behind a firewall. /Daniel This is not an answer, but similar problem. Having the same problem using .net ...Show All

• .NET Development Regex.Matches: Slow Processing

  I am using Regex.Matches to match somethings in a txt file, it works fine but when the text size increase it takes ages for the program to match something, if i try the same thing with Regex.Replace it goes fatster but using Regex.Replace ain't an option cause i would have to add allot of Regex.Replace lines just to cover most of the possibilities that i have. So i would like to know if there is any other way to make the Regex.Matches work faster. Here is an example of the code i am using: MatchCollection matchs = Regex.Matches(data, ".+was .+\n|.+rode .+\n|.+accepted .+\n|.+ate .+\n"); (Moderator: Thread moved to the Regular Expression Forum and Title tweaked for better Searching) Without a data ...Show All

• Visual C# Get Reference of Parent Object From Child Object

  I am creating a child object Y inside the parent class X. In Y i have to call a method in X after some conditional checkups. Right now i am passing 'this' as a parameter to the constructor of Y. Since X object is very big, i think it creates some performance overhead. What is the other way to get reference of parent Class from Child object. Code is somewhat like this Public Class X { private void Initialize(){ Y abc=new Y(this);} public void StartMe(){} } In Y I am calling Startme() in a function. Pl tell me the otherways to get ref of parent object. Thanks Hi, since your X type is a class it is a reference type, so when you pass it into the Y class constructor it is not ...Show All

• Smart Device Development Deploy Application.CAB file and Compact Framework 2.0

  Hi Everybody, This is Chandra from New Zealand. I am currently developing .NET CF 2.0 application on visual studio 2005 for windows mobile 5.0 platform. I want to distribute my application along with .NET compact Framework 2.0 to the customer in Canada. I created .CAB file for my application.But the problem is how can I include .NET compact framework 2.0 as well so that when the user runs my application.CAB file it also installs .NET compact Framework 2.0 along with the application. I will be sending only my application.CAB file to my customer in canada and he will be installing the .CAB file on his device. I want to deploy both my Application and CF2.0 to the device at one install. I wont be having physical mobile ...Show All

• Visual Studio Tools for Office Drag / drop file attachment from outlook

  Using .NET 2.0 I'd assume there is some easy way to accept dropping a file attachment from an outlook email message onto a form I cannot seem to find any good example of this. I see some very convuluded vb 6 methods, surely there is some easy way to do this Well, I found the answer, dumbfounded this wasn't as much chatter on this topic as I thought there would have been: http://www.codeproject.com/csharp/testemaildragdrop.asp df=100&forumid=51309&select=1804274&msg=1804274 ...Show All

• Windows Forms DataGridView - how to enter invalid entry in comboboxcell

  In C# 2005 DataGridView, I have a custom-made multi-comboboxcell (which derives off comboboxcell) that is populated with a list of values from a datasource. However, I simply want the user to be able to enter an item not contained in the list. The DataGridView always throws the DataError event and doesn't put the text in the cell. Any way to get around this I've tried setting the EmptyOnInvalid property in the InitializeEditingControl method of my custom cell class. But this does not work. ...Show All

• SQL Server Error Message: Setup Failed because MSSQL$SQLExpress is disabled for the current hardware profile

  When installing SQLEXPRESS I am getting this message: Setup failed because service MSSQL$SQLExpress is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property enabled. Anybody knows how to fix this problem Eitan You might want to try the following guidance on cleaning up the machine before reinstalling. http://support.microsoft.com/kb/909967 Michelle ...Show All

• Visual Basic Listview selected item

  I everyone... I've got a listview (details) ... and i'm trying to unselect any item selected... In a combobox, e.g, i can put this: ComboBox1.SelectedIndex = -1 I want to do this but in a listview control... can anyone help me Thanks I've already made it... lol ... i use this code: listview1.selectedindices.Clear() Thanks for the suggestion ...Show All

• Software Development for Windows Vista starting

  hi everyone, well... my graduation project is creating a layer or a product that generates workflows... so i was wondering if u could help me... i already tried doing a small workflow... but if there's something that could help me fet started i'd really appreciate it. if anyone has a link for some tutorial or anything i'd really appreciate it. thanks :) menna A good start is the official Windows Workflow Foundation website: http://wf.netfx3.com/ It also contains sample projects. ...Show All