RajeshR's Q&A profile
SQL Server Increase Aggregation Percentage
Is there a way to force the design aggregation in BIDS to 100% All of my dimensions have attribute relations defined (as indicated in the designer) yet I can get only around 35% aggregations defined. My main issue is an Excel pivot table that the user wants to create that has 3 row dimensions. When the Excel pivot table is first built, access is fast, but when the user drills down to bottom level of each dimension, the query takes a long time. We have a Hyperion Essbase/Analyzer report that shows the same information rather quickly. The difference I can see is that Analyzer has a list bottom function and the cube space in Essbase is very large (I think Essbase builds an aggregation for everything thus the faster access speed). As ...Show All
SQL Server Report Viewer Parameter Dropdown width
Does anyone know how to control the width of the parameter dropdownlist If you select "Multi-value" for the parameter (non-sp1 version) the parameter list is in a dropdownlist that is manageable in size. If you do not use the multi-value parameter, it looks like the width of the dropdownlist is determined by the width of the longest text of the returned parameters. Is there any way to control the width of the dropdown Thanks Rob here you can find all the info you need: http://msdn2.microsoft.com/en-us/library/ms345247.aspx . Also, maybe you'll find this post useful: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1084925&SiteID=1 ...Show All
SQL Server Microsoft.Jet.OLEDB.4.0 has not been registered. ??
Hi folks, We've got SQL2005 April CTP i64 running on Win2003 with SP1 appied (Itenium Proc). Last week, one of developer sent me an email with error msg, : Msg 7403, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. I ran Component Checker against that box and it found that MDAC2.8 with SP2 installed. I also found from MS site that Jet 4.0 SP8 i64 version available but the installation aborted due to newer version installed on the box. I am stucked. Any advice would be appreciated. Sunny Sunny, It sounds like the developer is executing code in a 64-bit application, and is looking for the Jet OLE DB Provider. There is no 6 ...Show All
SQL Server RDA push error
While trying to push a tracked table using RDA.push, I get the following error: Error Code: 80004005 The message cannot be built. The make message failed. Minor Err: 28581 Source: Microsoft SQL server 2005 Mobile Edition. All other tables in the database are getting pulled and pushed correctly. This table is different only in the larger number of columns, around 150. It has a primary key, no other constraints. Any help to find the reason for this error will be greatly appreciated. - Paul I see this message from time to time in my replication thread, and shortly afterwards processes using the SDF file will start complaining that it has been corrupted. Here is the stack trace ...Show All
Windows Forms Command Line in Windows Forms
Anyone, I have been asked to create a windows form (or multiple) that will allow the end user to run several command lines in one application. Basically the network guys need to be able to have 1 window opened and have 4 command prompts available to use at once. I know they could open 4 dos windows, but it's a long story. I would be happy just to know how to build 1. How can I make a windows form in VB.NET 2005 and have basically a dos prompt sitting there waiting for the user to type Thanks. You could start 4 hidden instances of cmd.exe and redirect their input and output to your form. Check out this MSDN article for the technique. There are problems however, it won't be able to capture ...Show All
Visual C++ How can I call service
Hi. How can I call service by C++ methods. For example, I have this service: https://2.2.2.2/MyService.asmx op=GetInfo Please, put the sample of using this service. For such issues, please use the newsgroups at http://msdn.microsoft.com/newsgroups OTP Thanks, Ayman Shoukry VC++ Team ...Show All
Smart Device Development How to connect to GPRS network from code?
When Internet Explorer is ran on my mobile phone it automatically connects to Orange GPRS network and I see a popup/hint on top of the screen saying "Connecting to GPRS...". I want to do the same in my application. Detect somehow that the network if available and just connect to it. I've looked in settings and iI think this is somehow connnected to modem connections but still I dont know how to start them from code. Any help/link will be appreciated. When Internet Explorer is ran on my mobile phone it automatically connects to Orange GPRS network and I see a popup/hint on top of the screen saying "Connecting to GPRS..." ...Show All
Visual C# VS2005 IDE freezes
I'm having an issue with VS2005 where when I try and save or when it tries to Save AutoRecovery information, the IDE completely freezes. I only just started having this problem, so I really don't know what the problem could be. Are there any suggestions / fixes for this issue With some searching through the forums, I have found other people that have similar problems, but no solution in sight! Any/all help would be greatly appreciated. No... But I have since reinstalled my development machine, and haven't noticed any problems since doing so... Unfortunately, that means I am completely clueless as to what might've been causing this problem. :( ...Show All
Gadgets Copyright problem? how did it happen?
What can I do now Hello, We're sorry but we won't be able to host your submission of Live Messenger Gadget on the Windows Live Gallery website. It looks like there's a copyright problem. We hope you'll give it another shot - just modify your submission, send it back to us, and we'll take another look. If you have any questions or comments, please send them through the feedback link on the Gallery website. This is an unmonitored mailbox, please do not reply to this email directly. Sincerely, The Windows Live Gallery Team Just as a thought, try changing the name. Microsoft probably doesn't like you using the name "Live Messenger" for the title of your gadget. Call it "Instant Messaging Gadget" ...Show All
Visual Studio Express Editions activating a file on a remote computer
how can i activate a file on a remote computer inside a lan connection i dont want the users to be administrators on this computer, instead i would like to insert the administrator user and password to the code. (the idea is to restart an application from a remote computer by any user who uses this program) i want to start an application on a remote computer by pressing a button in my visual studio program (on a local computer). ifthe user have to be an administrator on the remote computer to do that, i would like to insert the user and the password to the code instead of giving it to all the users that will use my visual studio program. ...Show All
Microsoft ISV Community Center Forums VB for applications accessing data from web pages
I have an application in MS Access which needs to extract text data from a Web site. How can I use VB (in MS Access) to link to the URL and get access to the underlying HTTP (so I can parse for the data I want ) I've done the same thing in Excel, using the Microsoft HTML Object Library and Microsoft Internet Controls to parse HTML. In the VBA project (Tools>References) set references to these two libraries. I found the following thread useful also: extracting data from an html page ...Show All
Game Technologies: DirectX, XNA, XACT, etc. More texture scaling problems
Simplified background: I have a texture that is 512x512, and I want to display it as the backdrop to a scene, the window size of which is currently 800x600. I need to load the texture from a stream rather than a file. I have loaded the texture, created a SpriteBatch, and am calling the equivalent of spriteBatch.Draw(texture, new Rectangle(0,0,800,600),Color.White); but it isn't exhibiting the expected behaviour(drawing a quad across the whole window). It is drawing the area 0,0,512,512... I've tried it with different texture sizes (smaller ones) and it seems to be drawing at the textures size, and completely ignoring the Rectangle's size. Is it really supposed to do that Using spriteBatch.Draw(texture, new Rectangle(0,0,800,600), ne ...Show All
Visual Studio 2008 (Pre-release) Entity Data Model Designer
I am using the March 2007 Orcas CTP and have created the EDM model using the wizard. Now, I want some changes so I am tweaking the CSDL, SSDL and MSL files by hand. Of course this leads me to long for the EDM designer tool. When will this be available in a CTP I just came in to ask the same question... Great minds think alike... Guy Burstein http://blogs.microsoft.co.il/blogs/bursteg/ ...Show All
Visual Studio Team System Flag a line of code for review
Is there a way to flag a line of code. I want to flag (not as in debug) just bring a certain part of code to be review or if I have a question on a certain part of the code. Thanks, Matt Hi Matt, I don't think that xml doc is the best tool for the thing that you're trying to do. I would suggest using Task List Comments ( http://msdn2.microsoft.com/en-us/library/zce12xx2.aspx ). Perhaps you could create a custom comment token for what you're trying to do. Regards, Michael ...Show All
Visual Studio Team System MSF Template - Risk WIT has a validation error
Hi, I am getting an error when trying to save a Risk WIT in a MSF CMMI and AGILE team project. There is no other information I have about this error other than what is recorded in the trace log: [WI] [Error, 3328, 1, 13:19:31.622] SvrEx: Microsoft.TeamFoundation.WorkItemTracking.Server.ValidationException: Forcing rollback ---> System.Data.SqlClient.SqlException: Forcing rollback at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior ...Show All