DRoden's Q&A profile

• SQL Server App receiving "Options" message from Service Broker

  I have an app receiving messages from SQL Service Broker when data is updated. (Messages are located at http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlnotificationinfo.aspx ) When I run this app against a remote SQL Server, I receive the message "Updated" which I expect. But when I run the same app against the local machine SQL Server, I receive the message "Options". Does anyone know if there are SQL Server options that must be set to certain values I can't seem to find anything that troubleshoots this message... either from a SQLServer- or a .NET standpoint. I ran a compare between the two databases. The local one, in 80-compatibility, needed the variou ...Show All

• Visual Studio Team System Conditional Code Analysis Builds

  Is there a way to simply (either via a macro or some other method) disable code analysis for a particular build. I know you can instruct VS to run code analysis on just one particular project, but sometimes I want to build quickly, without CA, like when the project I am building has many dependencies that I don't want to analyze at that time. If you are using Managed Code Analysis, you can turn Code Analysis off at the project level and then quickly run it when you need to by doing the following: C# and Visual Basic Projects: In Solution Explorer , right-click on the project and choose Run Code Analysis Web Sites: In Solution Explorer , right-click on the project and choose Run Code ...Show All

• Visual C++ Can't dynamically load VC8 library?

  I would say I am beginning to hate manifests... unfortunately, I am already well past that point. I have an application that dynamically loads a dll (i.e. LoadLibrary() ). It worked when I built with VC6. Now that I am trying to build with VC8, I get the following error: Runtime Error! Program: <path-to-my-program.exe> R6034 And application has made an attempt to load the C runtime library incorrectly. Please contact the application's support team for more information. I used to get this error trying to run the application itself, but was able to resolve it. Is there something special that needs to be done to use LoadLibrary now that one has to deal with these awful manifest things First, an externa ...Show All

• Visual Basic file rename in VB .net

  Hello I try to rename a file by file.copy(oldPathName, newPathName) then file.delete(oldPathName) File.copy works. But somehow, a message saying oldPathName is being used by another process, when it tries to delete the old file. Any idea why this happened and how to make it works. Thanks Quin Why not use the My.Computer.FileSystem.RenameFile Method to do the job rather than creating your own combination of copy and delete. There are more issues involved in recreating your own two step process such as timing, and fallback if failure occurs. I've found its almost always better to use whats available rather than trying to recreate the wheel. My.Computer.Filesystem.RenameFile htt ...Show All

• Visual Studio Package Load Failure

  I am developing a custom source control provider(like VSS).Its VS Integration package. I have added some menus and other stuff in that.I have tested the application in my machine in experimental hive.Its working fine.Now I need to install it in a seperate machine.I created a setup package for that.I have generated the registry entries using RegPkg exe in the SDK.I have imported those entries in the setup file.I have a Package Load Key which i have used using [MsVsShell. ProvideLoadKey ( "Professional" , "1.0" , "Package Name" , "Company name" , 300)] I have added the PLK in Resources.resx with the ID as 300.When i installed the setup package, I get to select the package in the Tools-->Op ...Show All

• .NET Development StreamWriter and pound character

  I want to create a text file with a pound (￡) character in it, when i use StreamWriter class with ASCII (System.Text.Encoding.ASCII) or ANSI (System.Text.Encoding.Default) encoding the ￡ (pound) character is either getting displayed as a or as some special character. It works fine if i use Unicode (System.Text.Encoding.Unicode) encoding, but i do would like my file to be in ANSI format rather than in Unicode format. Is there any way i can write a ￡ (pound) character with ANSI (System.Text.Encoding.Default) encoding Any help on this is would be greatly appreciated. This worked for me: textBox1.Text = ((char)163).ToString(); It depends on what codepage you have active. Judging from your name, it ...Show All

• .NET Development Error generating a DataSet from an OracleDataAdapter

  Hi, I'm trying to generate a dataset from an OracleDataAdapter but it returns an error as follows: “Retrieving the schema for oracleDataAdapter1 failed. Syntax Error: Expecting ‘.’, identifier or quoted identifier.” oracleDataAdapter1’s SelectCommand CommandText is as follows: SELECT ORDENS.COD_SEQL_ORDM, ORDENS.COD_INVT, SUB_ORDENS.DT_DATA, ORDENS.COD_OPER, SUB_ORDENS.C_PAPEL, SUB_ORDENS.N_QUANTIDADE, SUB_ORDENS.N_PRECO, THB_ORDEM.C_STATUS FROM ORDENS INNER JOIN SUB_ORDENS ON ORDENS.COD_SEQL_ORDM = SUB_ORDENS.COD_SEQL_ORDM INNER JOIN THB_ORDEM ON SUB_ORDENS.N_USERID = THB_ORDEM.N_USERID WHERE (TO_CHAR(SUB_ORDENS.DT_DATA, 'YYYYMMDD') = TO_CHAR(:DT_DATA, 'YY ...Show All

• SQL Server Hide 'New Subscription' in the explorer bar

  Hello We do not want the end users to know of the subscription capability. How do we hide 'New Subscription' link for a report. Thanks indersunny, Click on the Browser and you will get : - Assign the approciate security. elect one or more tasks to assign to the role. Task Description Consume reports Reads report definitions Create linked reports Create linked reports and publish them to a report server folder. Manage all subscriptions View, modify, and delete any subscription regardless of who owns the subscription. Manage data sources ...Show All

• Windows Forms Real Cut, Copy and Paste... How?

  How can I make my "Edit Menu" with "Cut", "Copy" and "Paste" in my windows application without need to type a code for each textbox that I have. For example: if (Clipboard.GetDataObject().GetDataPresent(DataFormats.Text)) textBox1.Text = Clipboard.GetDataObject().GetData(DataFormats.Text).ToString(); else textBox1.Text = "The clipboad does not contain any text"; In this case if I have 20 textbox I need to type 20 times the code. Is there something like a generic code The program will cut, copy or paste in any textbox I want, without the need to make a biblie of codes. Is this possible Well, of course has to be possible... but how Thank you. Try this: ...Show All

• Windows Forms Is there any property to keep a form on top but within an application?

  Top Most property of the form keeps the form on top of everything that's running. I want to keep a form on top but only within my application. Is there any easy way to that I know if a form got the focus from form_actiavted event. How can i know if my applciation got the focus. Regards Mani I have exactly the same problem as Mani - I have a little information window in toolbar style, which I have set to be topmost - but even when I switch to other applications, the stupid thing stays topmost over my other applications. Here's the code fragment from my MDI form: Private mActiveClientForm As DisplayActiveClient ... mActiveClientForm = New DisplayActiveClient mActiveClientForm . Show ( Me ) ...Show All

• Windows Forms Binding SortedList to a combobox

  hi I want to fill a combo box using the most elegant and professional way: I’m using a SortedList to hold my key/value data. I think it should be done using binding. I decided to use the new BidingSource control but I don’t know what to use in the Combo.DisplayMember property, because in my SortedList there is not identifier for the key and value. bindingSourceHistory.DataSource = ComboContentDates; cmbHistory.DataSource = bindingSourceHistory; cmbHistory.DisplayMember = Finally I use this code that works but I still think is not powerful as using DataBinding. I change the order to load the combo. By the way.. Can be the SortedList order backward for (int i = ComboContentDates.Count - 1; i >= 0; i--) { ...Show All

• SQL Server Where may I find information on SQL 2K5 and what it hooks in to?

  I'm new to server 2K3 and I know even less about SQL 2K5. I've read some 'reviews' on the program that talk about how it now 'hooks in to' other programs on a network. My question more precisely is what does it attach itself to and should I be careful about anything Developers here have been using SQL 2000 and have not made the jump to 2005 yet, so they can't answer my questions. So I decided to come here and try to learn the answers I'm looking for. Can some one point me in the right direction You will not see SQL Server beside the services which are installed on the server. Other than on the server is will have no implications on the network. If you start SQL Server Browser it will offer a service to fin ...Show All

• Software Development for Windows Vista InvokeWorkflowActivity doesn't call 2nd workflow

  I'm trying to get one workflow to call another one. I tried using the invokeWorkflowActivity, I set the TargetWorkflow to the workflow that I want to get called. It's in another project so I added the project as a reference. What else do I have to set up in order for this to work properly. I get no errors, the first workflow starts and then completes as expected because the call to start the workflow is asyncronous. The problem is that my second workflow doesn't seem like it's getting called. I only associated the 1st workflow, do I need to associate the 2nd workflow too Thanks, -Somsong Steve, The workflow is actually hosted on Sharepoint. I posted here too because there isn't much activit ...Show All

• Visual Basic Synchronize settings button isn't working

  Using VS2005 version 8.0.50727.42 RTM, I am experimenting with application settings to add some persistance to a VB windows app. Changing the scope of a setting from User to Application leads to a Configuration system failed to initialize exception at run time. I eventually realized that the Synchronize button on the Settings tab isn't working. It always gives me a dialog No user.config files were found in any of the following locations: [OK] No locations appear to have been searched, even though an out-of-date user.config file does exist in ...\Local Settings\Application Data\... Of course I can manually delete the user.config file to work around this but it would be nice if I could get the Synchronize button to do it for me. Do ...Show All

• Visual Studio Team System Cannot debug unit test

  Something's upset my VS.NET 2005 installation! When I now attempt to Debug a unit test, the IDE just locks up. No CPU activity, no disk activity, nothing! The unit test goes into the 'In Progress' state but never executes. I've breakpoints on the test class initializtion and the unit test method but neither are reached. I can 'Stop' the unit test which doesn't seem to do much so I 'Stop' the debug session and after a while I get a 'Stop debugging in progress...' stating that Debugging is being stopped but  is not yet complete... I can run unit tests [without debug] and they execute and complete as expected. I've not run any unit tests for a couple of weeks and it's possibly something with SP1 (recently installed) though I can ...Show All