Ganeshkumar S's Q&A profile

• SQL Server Error - The report server cannot decrypt the symmetric key?

  SSRS had been working fine on my comp till the time i insatlled VS 2005. I have started getting following error since VS2005 install The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help Bad Data. Why does this error cropped and how can i fix it I am using SQL Server 2000. Thanks So the actual data is never encrypted in the Reporting Services db Then in case I never made a backup of the encryption keys, and I have to delete it now, I wouldn't be losing any data; just co ...Show All

• Visual C# question about ... QueryStringParameter & HttpRequest ...

  I need to get Parameter from URL... like if URL shows "http://www.yahoo.com id=26 I need to get the Parameter "26" is it possible I think maybe it can be doen by use QueryStringParameter or HttpRequest is it correct if yes.. can you please give me a example or give me a hint to start thank you very much Hi, Are you developing asp.net application If so, use Page.Request["id"] to get the query string after "id" in the url. It returns a string value. or Request.QueryString as well. Detail info to see: http://www.codeproject.com/aspnet/QueryString.asp Thank you ...Show All

• SQL Server data being repeated.

  Hello, I have merged a master and detail tables into a fact table in order to create a cube, the master table let's say it's a sales table, and the detail the products of the sale, I merged both tables into a single fact table, so the data for one sale is being repeated once for each detail, this is the way I want. So if my sale has a total, let's say $100, and the detail has 3 products, when I visualize the cube the total for the sale is $300, and obviously this is incorrect, and let's say too, if there are many sales with different totals and differents details, the calculation can not be a simple MAX function or AVG, so, somebody know how I can show the data as I want Thanks in advance! odin_dark@yahoo.com.mx Dear , ...Show All

• Visual Studio 2008 (Pre-release) WCF on a Windows Service

  I created a WCF application inside of a managed Windows Service. I configured the Windows service to start up automatically when Windows boots. Finally, I created a deployment application that installs the service just like installutil.exe would. When I install my service and reboot, the service says that it is "Starting..." inside of the services manager. After about 2-5 minutes, the service quits starting and the status of the service goes blank. The service will not start automatically. If I start the service manually, it starts up and runs flawlessly. It is only the automatic startup that doesn't work. I discovered that when I comment out these two lines of code the service starts automatically: ...Show All

• Visual C# trap "enter" key on button to send "tab" to next control instead of fired OnClick(...)

  I have a window's form with many buttons, what I like to do is move arround all edit controls using "enter key" so every time you finish fill your data in an edit control hit enter and move to next control, I know how to do it usind SendKeys.Send( "{TAB}" ); But what about buttons, when I hit enter , button.onclick is executed. How can move to next control instead of OnClick(), but when you actually click with the mouse over this button you get OnClick as usual. Thanks in advance for your help and time. Edward Mac OK, let me put in this way, I would like to have an endless loop using Enter-key all around the data entry form, no matter what kind of controls are in. more deep about it: 1 ...Show All

• Software Development for Windows Vista Questions for a potential newbie

  I am looking into automation for testing purposes at a company that I just started working for. Since one of our applications is .NET, I wasn't sure how to automate the GUI until I found this forum. However, some questions/concerns have come up via various co-workers. First is the myth that .NET applications can't be automated. Next Wednesday I have to convince some other technical co-workers that it can (unless I'm mistaken). Also the concern came up that the developers will have to change their code to add Accessibility Functions in order to automate. I'm still trying to figure out if that's true or not, from what I've gathered so far, it doesn't seem like they need to change anything if they're using standard controls (compared to custo ...Show All

• .NET Development Adding Rows to Database

  I am trying to populating access database. Although I can retrieve data (as code below) I can’t manually add new row, say from textboxes. Dim connection As New OleDbConnection() Dim myadapter As OleDbDataAdapter Dim myDataSet As New DataSet Dim i As Integer connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Projects2005\MyDataBase.mdb" myadapter = New OleDbDataAdapter( "Select Customers.Name1,Customers.Name2,Customers.Name3,Customers.Address1,Customers.Address2,Customers.Address3, Accounts.InvTotal,Accounts.InvDate FROM Customers INNER JOIN Accounts ON Customers.AccNo = Accounts.AccNo " , connection) connection ...Show All

• SQL Server Analysis service does not remain started

  I have installed SQL Server 2005 Standard Edition for our Team Foundation Server install. I have verified the installation and all seems well, except that the Analysis Services service does not remain started. I get a message like "Some services stop if there is nothing to do." The Analysis service needs to be running in order for the TFS install to succeed. How can I get the Analysis Services service to remain started Thanks in Advance Since the default is to not start these services, this should be the correct behavior then. Are you checking the box during install to autostart the services Thanks, Sam Lester (MSFT) ...Show All

• Visual Studio Express Editions program starts with a right-mouse click...

  My program will be initiated by a menu selection from a right-mouse click. I'm trying to find the code which will tell the program the directory & file name of the icon which was clicked to start the process. Can someone help Thanks. Maybe we've misunderstood each other. My program is designed to be be initiated by a selection from a menu initiated by a right-mouse click. The command line does not accomplish the ease-of-use I have in mind. I can right-mouse click any icon on my computer and a list of options, including non-MS applications appears. These programs know how they were initiated because they process the corresponding file correctly. I'd like my program to do the same. Thanks. ...Show All

• Audio and Video Development Animating Width and Height

  My guess is that to animate and images width and height (as in shrink or grow the image), I need to display it as an object and then manipulate contentWidth/contentHeight. Is that correct Are there other ways to do this Thanks. Hmmm. So which method is more efficient/recommended 1) document["foo"].style.animateProperty(“contentWidth”,”1920px;1980px”,4) 2) contentWidth="scale-to-fit" document["foo"].style.animateProperty(“width”,”1920px;1980px”,4) ...Show All

• .NET Development Help - JIT Debugging Failure!

  Hi Mike, just read your post from the 24th of July, 2006 about JIT Debugging - with No. 4 you really hit the nail on the head. I de-installed .NET Framework V.1.0 and since then, I am constantly getting the failure message you mentioned: "cordbg.exe !a 0x108". What do you mean by SDK, and how can I get rid of this failure message Thanks a lot, Matias The blog entry you're mentioning is this one , right SDK stands for Software Developer Kit, and is a set of additional tools for the CLR. Cordbg is a deprecated simple command-line debugger that used to live in the SDK. Which runtimes are now installed on the box (running ClrVer.exe in the SDK will tell you) This is likely happening because ...Show All

• Visual Basic Including a vb6 exe file in VB2005 application

  Is it possible to include exe files in a solution, and execute them with commands Some problems are easier with vb6, so i just make an exe file in that, but is it possible to compile them with a VB2005 program so that i dont need to have ekstra exe files in the program folder that needs to be called. damn... Then i just have to include the exe file and call it from the application with the shell command Thanks for the reply ...Show All

• Visual Studio Express Editions How to print

  Hello everyone... I have a project that needs to print a customers file (word) - I've got this working using Microsoft automation (interop), but what i need to do is print a job sheet before printing this document. I have tried using rawprinterhelper class provided by microsoft, but it just sends a blank page to the printer. What I need to do is print a page that has just a few lines on it such as job number, printed filename, envelope selection etc. All this has been built into a string, but I can't seem to get this information to the printer. Can anyone suggest a way for me to get this done Thanks in advance for any help Justin Hi, I think following ...Show All

• .NET Development SqlCommandBuilder Will Not Build Update - Why?

  Here is the code that works: Dim CmdBldr As New SqlCommandBuilder, Tmp_da As New SqlDataAdapter Dim Tmp_ds As New DataSet, CmdTerms As New SqlCommand CmdTerms.Connection = ADOdotNetConn CmdTerms.CommandType = CommandType.Text CmdTerms.CommandText = "Select * FROM Terms" Tmp_da.SelectCommand = CmdTerms CmdBldr.DataAdapter = Tmp_da Tmp_da.Fill(Tmp_ds, "Terms" ) 'this works But the Tmp_da.UpdateCommand and InsertCommand properties are empty. Why It's driving me nuts. The problem was not the indexes. The Insert and Update commands would not be generated until the following two lines were added to the code after the fill. Without them, the da.update method fails ...Show All

• SQL Server Architectural Design Question ?

  We currently have a number of SSAS 2000 physical cubes and a single KPI virtual cube that our finance department reports from. A colleague is prototyping a new approach in SSAS 2005 and I’m looking for some feedback. Please see http://www.dailyware.com/SSAS2005Design.jpg for a high level overview. The lines in red illustrate custom .Net applications that push aggregated data from cubes to some other reporting source (SQL tables, XML ) that our finance department will report from. Thought that come to my mind include: many points of failure, significant custom development required, none-mainstream, high maintenance cost…. Thanks, Gary Hi Gary, Edward already provided ...Show All