Rajesh Govindasamy's Q&A profile

• SQL Server Database Mirroring: Cannot set the Mirror Server instance as the partner on Principle server

  Hi,   I’m trying to get database mirroring working but having problem when principal and mirror are not on the Domain. (I got it working once if both principle and mirror servers are on the domain.) Both servers have fully qualified domain names. Both have Windows server 2003 SP1 and SQL Server 2005 June CTP.   I used Local System Acct/Mixed mode and follow the Setting up Database Mirroring using Certificates article in the BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/df489ecd-deee-465c-a26a-6d1bef6d7b66.htm   I kept getting error when trying to set the Mirror Server instance as the partner on Pri ...Show All

• Visual Studio Express Editions How to publish

  When I published my application, I have no idea where it installed it self to what directory. My publish location is c:\program files\rma\ Yes it does put files here, but when I double click on an excutable file to install it, I think it went to c:\my document setting\etc. I want it to install to C:\program files\rma program\. Where is the setting path for this.. thank u Hi, If you have created setup project for distribution of you application then go the file system editor in setup project and in the Application Folder's Default Location Property put this value... [ProgramFilesFolder]\rma ...Show All

• Windows Forms ClickOnce Samples and Questions

  I have Beta 1 of VS 2005 and trying to use ClickOnce.  I have several questions: 1.  Is there any sample applications out there to look at the code   I am interested in an On-Demand sample app.  I would like to see how the calls are made to install the assemblies. 2.  If I set the Security tab of the Project's properties to&nbs ...Show All

• SQL Server Send Each row that caused error to email?

  Can somebody guive me alittle guidance in how to make this I have like 4 lookups but some can throw errors, and I need to know what happened when I go to the office in the moorning. Thanks How about a script component on the error path(s) that raise an event containing the relevant information. You can then have an errorhandler, scoped to the task, that sends that information via the Send Mail Task. -Jamie ...Show All

• Visual Studio 2008 (Pre-release) Are there any plans for typed XML data access?

  DLinq uses entity classes which can be generated from DB by SQLMetal. This allows typed access to data (you are not forced to use names in quotes and casting). This is great. But for XML there is no such possibility now. XLinq is much better than DOM but it is still untyped tree like DOM. This is disappointment for me. I would like to have possibility to treat XML in typed way (like XmlSerializer). Are there any plans for C# 3.0 or 4.0 to provide typed access (with LINQ pattern) to XML Ideally this should use W3C XML Schema mapping because XSD can define contract and Visual Studio offers IntelliSense and validation. ...Show All

• .NET Development XSLT param as text for nodename.

  I have xsl:template that will be passed parameters as the following <xsl:call-template name="bleah" > <xsl:param name="nodes" select="/Node/ToBeSelected" /> <xsl:param name="child" select="'somechildnode'" /> </xsl:call-template> the template needs to be able to do a <xsl:for-each select="$nodes"> <xsl:value-of select="./$child"> </xsl:for-each><br /> <Node> <ToBeSelected> <nodenotused>1234</nodenotused> <somechildnode>abc</somechildnode> </ToBeSele ...Show All

• Windows Forms How many projects should I use for my solution?

  I am working on a custom software for a local private school.  The application has four distinct functions. 1)  A calendar function similar to Microsoft Works Calendar. - The user can add appointments, workdays, days off, etc. and the event and time will be     display on the specified date 2) A address book feature - The user can input a variety ...Show All

• SQL Server ODBC Destination in SSIS

  Hi! I have a problem that stops me from using Integration Services as THE ETL tool. My goal is to load a data warehouse type of a database. The database is MaxDB (former SAP DB), but this is not the point. Let's take ANY ODBC compliant DB and assume all I have is ODBC driver - no OLE DB driver. I figured out how to read from ODBC source (using Data Reader and ADO.NET provider for ODBC). Now my question is how do I output/write my data into ODBC source When I try to use OLE DB Destination it does not give me an option to use .Net Provide for ODBC. I tried other "destinations" with no luck. I use this version of SQL Server 2005: (Mi ...Show All

• Visual Studio Team System Migrating to Team System from an existing environment

  I'm looking for some strategy whitepapers or documents on how an existing development organization should go about planning a migration to Team System. My development organization has a bug tracking system, we have a source control system, we have testing tools, and project management tools, and we maintain and enhance existing products built with VS2003, VS6 (C++ and VB6), and a bit of Java. We know we will be moving to VS2005 at some point, and we have new needs that our existing bug tracking and testing tools will not handle. So Team System looks compelling. However, we clearly cannot just shut everything down and start over with Te ...Show All

• SQL Server Row Count - Variable Name is Case sensitive

  I defined a variable called "NoOfRecords" for a Data Flow Task and within the Data Flow Task I am outputting records from Flat File to RowCount before doing anything else. I typed Variable name as "NoofRecords" in Advanced Editor for Row Count and it didnt like it. It gave the following error. Error at Load Customers[Row Count [138]]: The variable "NoofRecords" specified by VariableName property is not a valid variable. Need a valid variable name to write to As soon as I changed the VariableName to NoOfRecords, it worked. It looks like a case sensitive issue. Hi Sutha, Variable names are indeed case sensitive. This is By Design. ...Show All

• Visual Studio Team System How to develop my own dll with rules to append to fxcop

  Dear fxCop Team, I am new with FxCop and i'd like to know how to develop a class in vb.net to build as a DLL I have a list of own rules that a need to implement to FxCop but, I do not have any idea how to build this class. Is there code examples of class in vb.net to see Or some tutorial to take me step by step on this process regards, Marcelo I should have also added that you can ask us questions on this forum if you’re having trouble developing a custom rule for FxCop and we’ll do our best to help you out. -Todd King ...Show All

• .NET Development Generic Types

  would anyone know how to implement a single class for different types. This's my class Class CClass       Public Sub New(TheTypeShouldBe  AS  What  )         ' So That i can define a generict List of  'ThisShouldBeTheType'         Dim myList as NewList(Of TheTypeShouldBe)       End Sub         End Class Many Thanks Hi, and overloaded functions DO NOT Work Please would anyone know how to let the ...Show All

• Audio and Video Development Compression in AVI

  I have a program on a imbedded system (non-Windows) that now creates a raw rgb AVI video output. Naturally the bandwidth is a problem as the usage has increased. The ccd size has increased also. I would like to insert a lossless (a must!!) compression algorithm/codec into the program so that the bandwidth problems are reduced. Compression to 1/4 the size or smaller is a must. Can anyone help me with what lossless compression algorithm/codec is available in c/c++ source so that the output will be a compatible AVI file usable in Windows Media Player and the like Must be lossless and rgb. If no one here has an answer, who might I contac ...Show All

• SQL Server Using a Parameter for ORDER BY Clause

  When I try this SELECT * FROM db ORDER BY @ord in the query builder I get the window asking me to enter in the value for @ord.  When I enter the column name that I want to sort on I get a error saying 'Variable are only allowed when ordering by an expression referencing a column name.'   How do I create a query where I can use a parameter for the Order By clause. Actually, too many CASE expressions is fine. In fact, that is the easiest way to handle the scenario where you are sorting on different columns with different data types. This is due to the requirement that the data type of the res ...Show All

• Visual Studio Printing Crystal Reports

  Im using VS 2003 and Crystal Reports 10. Im trying to print a report to the default printer without opening a print dialog box. I have a table with IDs followed by text that populates the fields of the crystal report. If I use the crystalReportViewer1.PrintReport(); method, it uses the selection string to pull up the correct data, and will print, but it opens a print dialog box. If I use ReportDocument.PrintToPrinter method, it will print to the default printer without opening a printdialog box.  However, it does not use the selection string, and will print the first entry in my table every time. Is there a way to combine the functional ...Show All