Stephen Weatherford MS's Q&A profile

• SQL Server Enterprise Publisher to Express Subscribers (2005)

  I implemented a merge replication publication on a SQL Server 2005 Enterprise instance on a test server. On my laptop I have VS.NET 2005 installed with SQL Server 2005 Express. It's my understanding that I can subscribe to a publication with Express. I also have SQL Server Workgroup installed on my laptop so I'm able to use Management Studio to control the Express instance. The first issue I encountered was that you cannot subscribe to a publication if you are not on the same network as the publishing instance (it requires the actual server name). And in lieu of this I tried to implement Web synchronization, but had problems with SSL (which ...Show All

• SQL Server Unable to access MSSQLSERVER from client

  Hi, I have SQL Server 2005 installed and functioning (it does everything I've asked it to do locally). I also have the Express and Standard Editions installed on a computer running WinXPPro SP2 with all the WinUpdates applied. I also have VS2005 installed on this computer. I've done some development work on this computer, using VS2005 to create a SQLDB, connect to it, add data, etc. This is all okay. The problem is I cannot connect to the SQL Server from the client computer. I installed the client tools on this XP Pro box along with all the WinUpdates. Here's what I can do... I can ping the SQL Server by name (the name get ...Show All

• .NET Development preventing erasing background

  Hi, I am developing an application using .NET 2.0, in which, when I invalidate client area, I dont want its background to be erased. I couldnt find any overloaded invalidate() method, which allows me to do so. If anybody can help me achieve this, that would be great help. Eager to receive any comments, in this regard. Thanks, Ronak Thanks Michael. Deriving from panel class solved my problem. But it seems that by not having Invalidate(bool) overload, the way it used to be, things are difficult. Its impossible without using one extra indirection (for eg deriving class from Panel), which seems quite strang ...Show All

• .NET Development DOT Net Framework Compatibility Question

  I have RC1 of VS2005. I am told that the RC1 framework is compatible with the RTM V2.0 Framework where the beta-II framework was not. My question is how compatible There is a new .NET SDK that is supposed to require the 2.0 Framework. Is that compatible with the RC1 Framework To what extent are they interchangeable   Could I deinstall the RC1 Framework and install the RTM framework Is the new sdk compatible with the RC1 Framework Please try the forum .NET Development General [Discuss Base Class Library, design, and best practice issues of managed code. Enquire about the CLI, debugging, versioning issues, compatibility, o ...Show All

• .NET Development Deserializing an XmlNode via MemoryStream causes exception

  I have the following code in a catch block surrounding a webservice call: MemoryStream ms = new MemoryStream(); XmlTextWriter xmlw = new XmlTextWriter(ms,Encoding.UTF8); XmlSerializer xser = new XmlSerializer(typeof(ErrorDetail)); xmlw.WriteRaw(eSoap.Detail.OuterXml); ms.Position = 0; XmlReader xr = XmlReader.Create(ms); object o = xser.Deserialize(xr); xmlw.Close(); Where "ErrorDetail" is a class that matches the xml contained in the Detail property of the SoapException. The deserialization fails (and actually just reading the reader will do t ...Show All

• Visual Studio Tools for Office VSTO and Microsoft Office

  I am having trouble getting VSTO to work. When I go into Visual Studio to create the project I get a cryptic error telling me to check for disabled items in Excel (I have none) and then it instructs me to reinstall VSTO. A classmate suggested that it is because the University edition of Office (Microsoft Office Professional Enterprise Edition 2003) is crippled. Can anyone confirm if this is so Thanks, Michael I recently installed Office 2007 in addition to Office 2003. That seems to have broken my VSTO. I have now uninstalled Office 2007, Office 2003, and VSTO and reinstalled Office 2003 w/SP2 a ...Show All

• Visual C# Communiacting with DLL in c#

  I am working on a project which communiactes with a Radio Device (WR G303e Radio Receiver)connected to PC via USB. I comes with an API WRG3API.DLL implemented as a 32-bit driver. In the SDK it has examples for Delphi and C/C++. My Question is..... How can i import/communicate (with) this dll to work in C#. I am looking for some1 2 reply... please help me if any1 out there has any info about this issue... Kind Regards t4urean I think you can take a look of P/Invoke in C#, which can invoke the functions of a dll. All you have to do is to make a method signature like this using dllimport attribute [DllImport("someLib.dll&quo ...Show All

• SQL Server Is it possible to execute a container regardless of the checkpoint file?

  I have a situation where I need to make sure a task executes regardless of whether the package starts from a checkpoint or not. Is this possible Here's the scenario: I have a package with 3 tasks {TaskA, TaskB, TaskC} that execute serially using OnSuccess precedence constraints. The package is setup to use checkpoints so that if a task fails the package will restart from that failed task TaskA is insignificant here. TaskB fetches some data and puts it in a raw file TaskC inserts that raw file data into a table. Problem is that the insertion violates an integrity constraint in the database - so it fails. The problem is ...Show All

• SQL Server New SQL Server 2000 worm?

  Hi all. My SQL Server 2000 SP4 installation running on Windows 2003 server (SP1, all patches current) has been infected TWICE by something that Sophos can't detect. The symptoms are that an account called SQLsys is created on the machine and is made an administrator. A service called "ApptoService spoolsrv" is created. An executable called syss.exe is also created in a few places. After infection the machine immediately starts attacking other computers on the network. I had Windows Firewall running, with ports open for SQL server and Remote Desktop. I ran the MBSA, it didn't find anything open. I even ran the beta MS web tool for ...Show All

• Visual C# RichTextBox : Text color

  hi.. i have a richtextbox in which im displaying some messages, i want to change the color of some text . is there any way to that thanx Hi, yes you can, select the text and use the SelectionFont and/or SelectionColor property: richtextbox.SelectionFont = new Font("Verdana", 10, FontStyle.Regular); richtextbox.SelectionColor = Color.Blue; ...Show All

• .NET Development "Cannot allocate a new command id" exception when creating ContextMenu with lots of MenuItems

  I am writing a c# windows application that displays lots of information to the user via a ContextMenu.  I have encountered a problem where the ContextMenu doesn't display after a large amount of MenuItems have been displayed.  To better understand what I am saying, here is a simple example that will reproduce the problem.  Create a c# windows application with a button and an event handler for the button click.  In the handler method call the function included below.  The first and second time, the menu will render (the position is off but you will get the idea).  The third time, the menu never appears.  I h ...Show All

• Windows Forms how to add more panels in splitContainer

  hi, in standart split container is 2 panels divided by splitter, i wnat to add moe panels and more spliters of course, maybe someone can offer something well actually i thougth to create a control like in reports with 3 panels 1 for header 1 for body and 1 for footer, mabe someboy have other ideas i still didn't find a good way to do that ...Show All

• Visual C# Post-build event stripping carriage returns

  Howdy all, I'm using VS 2005 (.NET 2.0).  I have a windows forms application that consists of two projects.  One project is the application itself, and the other project is the "setup" project.  I want to have the setup project copy the msi file to a "ForDistribution" directory via a Post-build event.  The post-build event was added to the setup project as follows: 1.) Click on the setup project in the solution explorer. 2.) In the Properties window, select PostBuildEvent. 3.) Click on the ellipses (...) to open up the "Post-build Event Command Line" editor. 4.) Enter the following lines into the editor: IF NOT EXIST " ...Show All

• Visual FoxPro editbox programmatic change

  I am looking for an easy way to determine if I've made interactive change in an editor box. The issue is that there are about 16 controls on a container, they are initialized from a table record thus their values at activate time generally are not trivial default. I have to save the changes with a SAVE button if I made any but I want this button's click method to quickly determine which control values have been changed. I do not want to do REPLACE for the fields with values that haven't been changed. In case of simple controls like a combobox I can store the initial value in Tag property and do the comparison programmatically. Sometimes t ...Show All

• Visual Studio Express Editions Reference by name property

  My question deals with referencing one object by it's name property when it is instantiated from within another object. exp. A windows app project is created with the default form1. A new empty class is added, which inherits form. (named the class myform) In the constructor, the .name property is set to myNewForm Back to the default form1's load event, I instaniate a new myform dim mf as new myform At this point the object is referenced as mf Now the point of all of this......when you add an object in the designer, why is the object able to be referenced from its parent by it's name. like when a textbox ...Show All