Pierre Thorey's Q&A profile

• SQL Server Can This Be Accomplished in My Time Dimension in my AS2005 Cube?

  In my AS2005 cube, I have a time dimension with the following attributes: year, quarter and month. Also, there is currently no hierarchy by design. Is there a way to make a custom attribute/time period that reflects the last 12 months (R12M) and work in the same manner such as year, quarter and month The time dimension would then have: years, quarter, month and R12M. As a result, a user can drop a measure such as Sales Amt and then add the R12M attribute from the time dimension and would then receive the total sales amount for the last 12 months. I hope that made sense. I can and have written a calculated member for R12M Sales, b ...Show All

• .NET Development Web Reference

  I am migrating a class that leverages a web service from Dev to Prod.  The problem seems to be that when i set the properties of the reference I get the error "The underlying connection was closed:  The remote name could not be resolved".  That is because the dev can't "see" the prod and I don't have and can't have VS.NET installed on Prod. What can I do What property are you setting that returns that particular error message It sounds to me like the problem is the Url property that is embedded in the class definition. It's possible that your problem will go away if you set the Url property on the property clas ...Show All

• SQL Server Unable to modify database design

  I have replaced the installation of MSDE 1.0 with MSDE 2000. Prior to installation of MSDE 2000, I can perform the activities of all database role. Now, I can only add, change and delete data - no more database design. What should I do to regain database design permission I'm using "sa" user with blank password when I login to MS Access Project. JonM, Thanks for the info. Unfortunately, I dont have installer for SQL Server tools. I would instead use linked server and some trigger to scrub data from other sources. ...Show All

• Smart Device Development can't add a cert in a device application...

  These are the steps I've taken... Right click the project node in the solution explorer Click Properties Choose the Device tab on the left Check the 'Authenticode Signature' checkbox Click 'Select Certificate' There were no certs visible in the 'Select Certificate' dialog box so I chose 'Manage Certificates' I then imported the proper cert from the 'Manage Certificates' dialog box Browsed to the cert in the 'Trusted Root Certification Authorities' Selected the correct cert But now I can't find a way to add that cert into the previous dialog box or my project.  Drag and Drop is disabled, there is no Add or Ok button.  Is ...Show All

• Visual C# pulling forms out of applications.

  Is there a way to pull out what forms are in a particular application that get's passed in Also does any one know how to find out the name of the exe file that call's the dll Anything would be very helpful. Thanks, Matt In terms of Form-based classes contained in an assembly, you could use reflection to enumerate all the types in an assembly (see Assembly.GetTypes) and see if any derive from Form (see Type.BaseType). You can get the main assembly via Assembly.GetExecutingAssembly(). If you have an object, and you want to know what assembly is is from you can use Object.GetType() to get it ...Show All

• Visual C++ VC6 projects trying to link to MFC42 in VS2005

  I have several MFC DLLs created with VC6. When I import the projects to Visual Studio 2005 and try to build I get fatal error LNK1104: cannot open file 'mfc42.lib' . I gone through the project settings several times (and there are no #pragmas), and I just can't figure out why the project is trying link to MFC42. Yup. Presumably the linker knows which lib is trying to link to the missing module, so it would be nice if the linker showed it in the error. ...Show All

• Visual Studio Express Editions Make a socket

  how to use socket for reciving and sending with tcp/ip protocole in Vb http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpqstart/html/cpsmpnetsamples-howtonetworking.asp Best regards, Johan Stenberg ...Show All

• .NET Development WSE 3.0 question

  I am new to WSE 3.0. I was trying to use one of the sample which comes with WSE 3.0. The sample demonstrates how to use kerberos security. But when I try to run the sample I get following exception: "Security requirements are not satisfied because the security header is not present in the incoming message" I also tried to create kerberos token and set it on proxy, but no success Do I have to make any changes to the sample before I can run it. Thanks in advance KDV Depending on whether you are using the code example or the policy example have you update the policy to have the name of the host you are talking ...Show All

• Visual Studio Team System Checkin with some unchanged files gives error code of 1

  Using Team Foundation July CTP and the command-line interface (h.exe). If I check out a number of files, edit a few (with a build) then check them all in with h.exe, it does the right thing (checks in the changes files, undoes the edit on the unchanged files).   However the command returns a non-zero error code of 1: "There are no remaining changes to check in". Actually it DOESN'T do the right thing, it seems to essentially undo all checkouts (I am not sure if the changes files are undone as well ).  Is this a bug or by design   I don't see an easy way to manually undo the edit on the unchanged files to prevent getting ...Show All

• Microsoft ISV Community Center Forums Colored Named Ranges

  Hi, Am trying to color a particular cell in an excel sheet based on the values of other cells. For eg i have the value 10 in cells a2 till a10.I want the macro to scroll through these values and compare each one of them with a cell in the same worksheet(say F2) which has a value of 10.If all the values in the range a2 till a10 are 10 then color F2 with green.If one or more cells in Range("a2:a10") are not equal to the value of Range("F2") then color the Range("f2") in red.Am very new to VBA so not able to accomplish this.Any help in this regard will be greatly appreciated. Rgds       ...Show All

• Visual Studio Express Editions How to get the returned dataset from storeprocedure

  VB 2005 Code cmdFind.CommandType = CommandType.StoredProcedure cmdFind.Connection = cnAlfol cmdFind.CommandText = "POS_ItemFindDetailByItemID" 'define parameters cmdFind.Parameters.Add(New SqlParameter("@ItemID", SqlDbType.BigInt, 50, "@ItemID")) 'define parameters cmdFind.Parameters("@ItemID").Value = CType(value, Integer) cnAlfol.Open() XXXXXXX < ------ cnAlfol.Close() Storeprocedure Code ALTER PROCEDURE [dbo].[POS_ItemFindDetailByItemID] -- Add the parameters for the stored procedure here @ItemID int AS BEGIN -- SET NOCOUNT ON added t ...Show All

• Visual Studio Team System Test-Project (vstesthost.exe) and app.config

  Hi, I'm pretty frustrated because I can't unit-test my application because the app.config from the test-project is not being used by the vstesthost.exe. Does anyone know how the heck to get the test-environment of VS2005 to use the app.config of the test-project thank you! Hi, Im having the same problem, and i found that the configuration file been used is not the expected <AppName>.exe.config but there is a configuration file named vstesthost.exe.config been used insted. My application configuration file is been copied to the "Out" directory in the TestResult folder but the Test Engine is not using it. I debuged the application ...Show All

• .NET Development using sax to parse large xml files

  I am trying to use SAX for the first time. I got as far as this: this .fileStm = new FileStream(path, FileMode.Open, FileAccess.Read); reader = SaxReaderFactory.CreateReader( null ); reader.Parse( new StreamInputSource(fileStm)); and i have no idea how to actually get the data from the reader... If anybody has a sample code to parse the document and put data into some kind of a structure like hashtable or an arraylist - I would really appreciate it ! Thanks! Forcing XmlReader through a SAX layer is possible but adds overhead that makes the comparison somewhat unfair.  You should be comparing real customer code - one writ ...Show All

• Visual Studio VSS->Rights by Project Diabled for Admin

  Hello, I created a database in VSS but when I added users and tried to assign rights by projects i found following options diabled for all user.    -Rights by Projec...    -Rights Assignment for User...    -Copy User rights. I have logged in as Admin. How can I get these options enabled....Please Helo. Thanks, Rafiq Dear Mr.Alfredo Mendez thanks for ur info.... its working fine..... Rafidheen.M Project Manager, Axon Infosoft India Private Limited, Coimbatore - 641664 rafidheen@yahoo.com ...Show All

• Windows Forms Adding an icon to the form taskbar when using a form with no border?

  Hello, I am making a form in Vb.net using a skin so I do not have a border on my form, but I would like an icon to show up in the taskbar when the form is opened.  Is this possible   I haven't been able to find anything that says you could.  Can someone please help, point me in the right direction, or confirm that this can't be done Thanks, Marc Paul, I tried it on an XP system and the icon is visible in the taskbar. It must be a Windows 2000 issue or an issue with my computer itself. Thanks for the help. Marc ...Show All