sanjeevm's Q&A profile

• SQL Server Service Broker Table Copy, file send?

  Hi There I have a table at my initiator, i have a copy of this table at my target, every morning i want to refresh the table at the target with the data from the initiator via service broker. What would be the best way to do this One major consideration would be that this table would be very large +- 1.6 million rows. I was thinking of exporting the table to file like a csv, compressing the file and then sending it via service broker. Then at the target i would uncompress and bulk copy the data into the table at the target. But can this be done How would one go about sending a file via service broker For example if i wanted to send a .csv or something via service broker how would i do it I know i can send binary dat ...Show All

• Software Development for Windows Vista VB.NET 2005 MSVidCtl works but no audio

  I am using MSVidCtl active x to display video. It works fine, but I am having trouble getting audio to play. I really don't know where to start. Could someone point me down the right path. Thanks I'm looking for the same. For a work around listen to the microphone. After I sent a Tune Request I can listen to the audio through the microphone if that it was the primary device ...Show All

• SQL Server SSRS can't log in using Management Studio

  Hi, I have serious trouble trying to log in to SSRS using Management Studio. I have installed SSRS to existing named instance of SQL 2005 than I have configured it using Reporting Services Configuration tool. At this point some thing was not OK as initialization button is grayed out (although it indicates that initialization went OK). At this point everything seems to be OK the reporting site is available through web browser. Alas when I’m trying to log in into reporting services using Management Studio I get error “Unable to connect to remote server. No connection could be made because the target machine actively refused it (System)” I was trying different authentication methods and different configuration. I was trying to set up permi ...Show All

• SQL Server Import export wizard

  In sql2k i can select bunch of tables in EM and export to a different db also I can schedule this activity. How to do the same in SQL2K5 Right-click on the database Point to Tasks-->Export Data Go thru the wizard, selecting the tables that you need. You will be prompted to save the resultant SSIS package somewhere. Once you have saved it you can schedule it thru SQL Server Agent. -Jamie ...Show All

• SQL Server Mon- Fri Bit fields Query

  I am having trouble figuring out how to complete this any help is appreiciated. I have Mon , Tues , Weds , Thurs , Fri as bit fields I need to write a query for a report to see if the value is true, and display M , T , W , Th , F in a column Days if they are scheduled that day example: Mon and Wed I got on the bus the checkboxes are set to True, I want one column in the report Days : to display M, W I was playing around with the code, and I don't believe this is what I am trying to do let me explain a lil more. I have a table that does a transportation schedule. It has Mon, Tues, Wed, Thurs, and Fri as bit data types so that I may have checkboxes on the front-end. I need to build a r ...Show All

• Commerce Server CS 2007 Starter Site - stored procedure 'dbo.inv_CheckInventory' doesn't exist

  Downloaded CS2007-StarterSite-En.exe and installed successfully. However, when I attempt to add a product to my cart, an unhandled exception occurs: Component Execution failed for component[0x2] hr: 0x80131509 ProgID: Commerce.CheckInventory The stored procedure 'dbo.inv_CheckInventory' doesn't exist. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: Component Execution failed for component[0x2] hr: 0x80131509 ProgID: Commerce.CheckInventory The stored procedure 'dbo.inv_CheckInventory' doesn't exist. Source Error: Line 152: ...Show All

• Windows Forms Binding text box fields to combo box selected value

  I have a small C# windows application with few text boxes and a combo box. I need to bind text fields to the value selected in the combo box, it works fine for the first selection but when I try to select another another item during the same session it gives me an error: "This causes two bindings in the collection to bind to the same property. Parameter name binding" . I think I need to bind the text boxes to may be the selected index change event of the combo box, but I am unable to implement that correctly. private void cmbEmployeeList_SelectedIndexChanged( object sender, EventArgs e) { txtFirstName.DataBindings.Add( "Text" , objDSEmpTrkSys, "EmployeeInformation.FIRSTNAME" ); txtLastNa ...Show All

• .NET Development XMLHTTP file size limit ?

  Hi, I encounter this problem while developing a Jscript app, when i try to upload a file larger than about 10K and then download the same file again from a JBoss App server, i could not get back my original file, the file appears to be trancated. The office system i used is chinese, the file encoding i used might be double-byte, is this a problem any idea William The size limit for XMLHTTP is much higher. You may try Msxml2.ServerXMLHTTP.4.0 or WinHttp.WinHttpRequest.5.1 objects instead of XMLHTTP to check if it's XMLHTTP-related or server-related issue. If you figure out that XMLHTTP is the culprit, please provide the full version of MSXML you are using. Thanks, Anton ...Show All

• .NET Development How can I apply validation on a file for .doc ,lrtf ,.pdf or text files??

  I am trying to upload a file and apply a validation on the file for .rtf,.doc,.pdf or text file. How do I go about it Are you uploading the data as xml and want to verify against the schemas for .doc .pdf etc For example, you have saved your word document as an xml file, then you can validate it against the wordML schema using the .NET validating XmlReader. If not, can you describe your scenario little further Thanks, Priya ...Show All

• Windows Live Developer Forums Robot Invaders Contest Winners

  It's time to annouce the winners for the Robot Invaders contest. The contest ran from May 15th to September 15th and in the end 53 Messenger bots were accepted as valid entries in the contest ( per the how to compete guidelines ). Each entry to the contest was judge by three judges separately using the Judging Criteria outlined on the How to Compete page and then the judges scores were averaged. There were a lot of great robot's submitted but here's the winners: Title Prize LiveBot Grand Mother Nature 1st Spleak 2nd Mobile Record bot 2nd Virtual Secretary 2nd Dr Phile Knowledge 2nd Comtec Travel Bot 2nd Search Bunny 3rd ...Show All

• Visual Studio Express Editions HELP WITH RTF

  How can i get my programm to add diffrent fontstyles and read the selection font out of the Font combobox en the Size combobox I need help fastt Try something like this (you need to add error checking): Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load For Each fnt As FontFamily In FontFamily.Families cboFonts.Items.Add(fnt.Name) Next cboPoints.Items.AddRange(New Object() {"8", "10", "12", "16", "24", "36", "48"}) End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click RichTextBox1.SelectAll() RichTextBox1.Sele ...Show All

• Visual C# Embedded manifest in .Net App

  How to make someapp.exe.manifest file embedded in someapp.exe In C++ application we could set manifest using manifest tool. I don't want to have separated from main application .manifest file. I've added manifest in C# project, but there is no special settings applied to manifest files in VS2005. The only option I've found useful is Copy to output directory -> copy if newer. I'm not sure what you mean. If you're talking about the Assembly manifest then that is embedded in all C# applications. You can't *not* embed it. You can access it using the System.Reflection namespace. ...Show All

• SQL Server MS Office Integration & SSIS

  Using SSIS, every month/week I have to generate serveral excel files. I need to find a way to automatically format these excel files (Bold, Headings in Different color etc.). Is there a way to integrate MS Office excel task in SSIS Thanks Shafiq shafiqm wrote: Using SSIS, every month/week I have to generate serveral excel files. I need to find a way to automatically format these excel files (Bold, Headings in Different color etc.). Is there a way to integrate MS Office excel task in SSIS Thanks Shafiq The only way is to use the Office Primary Interop Assemblies (PIM) and do this programatically from a script task. -Jamie ...Show All

• Visual C++ Native C++ Or C++.Net2005!!!???

  Common Guys, I Did Many Test, And Always The Rersult Tell Me That Native C++ More Faster Than C++.Net.How Is This Plz Tell Me, Does This Is True Thats right, but there are several things that you must remember when using managed code. It is much safer than native code. You have to pay a price for this safty and ease. Some people find that the speed loss is acceptable for the safe coding. The only way you can see the difference and if the speed loss is acceptable for you is to create a sample app and test it. ...Show All

• Visual Studio Migrating from VS2003 to VS2005 C# WinForms application using CR

  Ok I have a project that was in VS2003 that we are trying to migrate to VS2005. I have managed to get the project to build successfully and I can view most of my reports. However, there are one or two of my reports that keep failing with: Error 2 Custom tool error: "Code generator 'ReportCodeGenerator' failed. Exception stack = System.Exception: Load report failed. ---> System.Runtime.InteropServices.COMException (0x800001FD): Invalid field name. at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocument ...Show All