j_o_h_a_n_n_e_s's Q&A profile

• SQL Server Can we send a blob in a message.

  Say i want to send a blob in a message from queue A to queue B. These locations can be geographically different. How can i implement this Also anything which i want to send as a message should be stored in the database. and then I should store it in a variable. this can be used as the message body. am I right Hi Remus, From what you have said before that SSB cannot use HTTP. But the following statement from BOL says the opposite: An endpoint is a SQL Server object that represents the capability for SQL Server to communicate over the network. Each endpoint supports a specific type of communication. For example, an HTTP endpoint lets SQL Server process specific SOAP requests. A Service Broker end ...Show All

• Visual C++ I want to edit the .rc file in vc project, from where can I open the text editor to edit the .rc file ?the steps to do it ?

  I want to edit the .rc file in vc project, from where can I open the text editor to edit the .rc file the steps to do it when I replace the bitmap file in the res folder with another similar bitmap file with the same file name, and I compile and run the program,it give me some error: CVTRES : fatal error CVT1106: cannot write to file .\Debug\SiteViewer.res : fatal error LNK1123: failure during conversion to COFF: file invalid or corrupt Error executing link.exe. Can you tell me the steps of how to change the bitmaps file in the res folder Thanks ...Show All

• Visual Studio Tools for Office Customizing the Ribbon: TabOutlineMode

  Hello helpful people, I am attempting to add a button to the Outline Mode tab in Word (using <tab idMso="TabOutlineMode">), but Word complains that this idMso does not exist (I looked it up - it seems to be the correct id) I speculate that this is happening because the outline mode tab does not exist when Word launches - it only shows up when outline mode is enabled. I have tried automatically switching over to outline mode: private void ThisApplication_Startup(object sender, System.EventArgs e) { Globals.ThisApplication.ActiveDocument.ActiveWindow.View.Type = Microsoft.Office.Interop.Word.WdViewType.wdOutlineView; } But I get the same error. I suspect that the ribbon is loading before ThisApplication_Startup i ...Show All

• SQL Server Adding SQL Reporting Services to SQL Server 2005 SP1

  I'm using Reporting Services Configuration tool to add the Reporting and ReportingTemb databases. Once the have been created, the tool attempts to upgrade the databases and can not create a script. This are the errors I see from the from the Reporting Services Configuration Tool after creating the databases: ! Verifing Database Version The Database version (C.0.8.40) does not match your Reporting Services installation. You must upgrade your Reporting Services database. ! Creating upgrade script for database version C.0.8.40 ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does not match a supported version. at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(Strin ...Show All

• Visual C++ Problem with Rich Edit control

  I am using a rich edit control and when I try to find some text using FindText control it is always returning -1. I am using FINDTEXTEX structure and dwFlags perfectly but it is always returning -1 I tried using the methods AfxInitRichEdit and AfxInitRichEdit2 then also it is giving the same results Is ther any solution to this problem According to documentation, -1 is returned when no matches are found. This can be caused too by incorrect initialization of passed data. For example, you did not define correctly the lpstrText value.   Maybe you should show us some eloquent details   ...Show All

• SQL Server Background Color in Matrix Report

  I have the following: =IIF( Sum(Fields!Percentile.Value, "RegionalSnaps") >= 0.10, "Yellow", "White") I only want the ones above 10% to be yellow, otherwise white. Any ideas on why the entire range of cells are yellow and not just the one above 10% The datatype of the field that I am reporting on is a money type. Here is the code, its textbox2 that I am referring to. < xml version="1.0" encoding="utf-8" > <Report xmlns=" http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition " xmlns:rd=" http://schemas.microsoft.com/SQLServer/reporting/reportdesigner "> <Body> <ReportItems> <Matrix Name="matrix1"> ...Show All

• Visual Studio VsIdeTestHost.msi missing in last SDK?

  I can't seem to find the VsIdeTestHost.msi file that is referred in the VsHostIntegration sample unit tests. I can't find the wix scripts that would enabled to rebuild it either. Anybody has an idea I also have problem with VsIdeTestHost. I have VS SDK Sep RTM, and I just installed Dec CTP. But when I want to run my old project, there was pop up window says something like: "The Add-in VsIdeTestHost failed to load or caused and exception. etc etc....". It asked if I want to remove this Add-in, but I did not remove it. The error message is the system cannot find the file specified with error number: 80070002. Does anyone have any idea about this Regards, ...Show All

• SQL Server Creating full-text indexes on a table in a publication

  I have a table that is in a one way transactional publication. I need to create a full-text catalog on this table and have that catalog exist on the subscriber as well. I understand simply creating a FTC for an object in a publication will not cause that FTC to be replicated to the subscribers. I have scripted out the command and tried to use sp_addscriptexec to push it to the subscriber. When I do this, I get the following error: Last 183 characters in 'sqlcmd' output buffer: Changed database context to 'database'. Msg 574, Level 16, State 1, Server SQLSERVER, Line 2 CREATE FULLTEXT CATALOG statement cannot be used inside a user transaction. Also, when this script is run directly from the subscriber, it works fine (but since the subscribe ...Show All

• Windows Forms autocomplete AND dropdownlist combobox

  I want to give the user the functionality of the autocomplete, allowing them to enter one or more letters and receive a list of possible entries, whilst also ensuring that the user can only select an item from the list and not type any old thing. I know that I cannot use the dropdownlist list option along with autocomplete, but how can I make sure that the user does not enter invalid data Basically, at all times during the edit process, I want the data in the combo to be valid, so if a user enters invalid data, maybe the previously selected entry should be selected Whatever works best. I want to have the functionality of both autocomplete and dropdownlist. You could create a derived version of the ComboBo ...Show All

• Visual C++ Timer not getting fired up

  I am using System.Timers.Timer to get a job done.However the elapsed event is not getting fired up. So I want to come up with custom timer or similar to that which will behave in the same way as of timers. Any body has any ideas thanks     Hello Re: Timer not getting fired up Such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 For such issues please use the newsgroups at http://msdn.microsoft.com/newsgroups . OTP Thanks Damien ...Show All

• Visual Basic visual studio 2005 is running slowly

  I am developing a windows application(converting vba to vb.net). some of the forms have ten or more tab controls. Each tab control has many text boxes,listboxes,radio buttons. when i change a name of the control it takes 30s ---2min. when i copy and paste some control from one form to another it takes 1--5minutes. this does not happen all the time. any solution/advice would be appreciated. navigationbar is disabled/wordwrap is disabled ms vs 2005 ver 2.0.50727 os-windows xp sp2 cpu-p4-3000mhz ram-2g machine-hp you are right dan.this is what i did 1)my form already has 950 controls. so i added a new textbox and changed the name a few times. it was fast. then the auto recovery featu ...Show All

• SQL Server ODBC SQLFetch problem

  Hi, I have ODBC code reading data from a XLS file. It opens the file, reads the sheets and columns available, then presents a dialog to allow the user to select which columns are to be used to load the data. All of this works, almost. It is a simple "Select A,B,C FROM Sheet1" using SQLExecDirect When using SQLFetch it always skips the first row of data. Thanks, any ideas would be great. Keith Turns out that the Excel driver expects the first row to be the column names. There is supposed to be an option to turn this behavior off, but it has not worked in the past. I am not sure if it has been fixed. Here is the link to more information. http://support.microsof ...Show All

• Visual Studio Can Sandcastle build intellisense file from an assembly?

  I want to build intellisense file from an assembly which has not an xml file associated with.I know that NDOC can do this,how about sandcastle Thanks in advance!! How does this differ from the XML comments files generated by Visual Studio as they are used for intellisense too by default Eric ...Show All

• .NET Development Can MarshalAs interop attributes be set dynamically or overloaded?

  Let's say I have an ATL based COM object that exposes the following method signature: STDMETHOD(Store)(/*[in]*/ BSTR bstrEncoding, /*[in]*/ BSTR bstrMessage, /*[out, retval]*/ long *plResult); The first parameter (bstrEncoding) in this method indicates what type of buffer (i.e. either "ansi" or "unicode") is actually contained in the second parameter (bstrMessage). To correctly use this method from managed code I need to be able to manipulate how the second parameter is marshalled in my custom RCW (created by using reflector to dissassemble a VS generated interop assembly). For example: If a unicode string is passed as the second param: int x = Foo.Store("unicode", someString); I'd simply accept the default ...Show All

• Software Development for Windows Vista installutil.exe installing windows service

  I'm tring to install a windows service and keep getting the following message, can anyone help with this TIA C:\Program Files\My Application>installUtil.exe MyApp.exe Microsoft (R) .NET Framework Installation utility Version 2.0.50727.42 Copyright (c) Microsoft Corporation.  All rights reserved. Running a transacted installation. Beginning the Install phase of the installation. See the contents of the log file for the C:\Program Files\My Application\MyApp.exe assembly's progress. The file is located at C:\Program Files\My Application\MyApp.InstallLog. Installing assembly 'C:\Program Files\My Application\MyApp.exe'. Affected parameters are:    logtoconsole =    assemblyMyApph = C:\Program Files\My Appli ...Show All