robbie__'s Q&A profile

• SQL Server update statement

  Newbie Question: Im trying to update a table column to a new value and I receive an error, here is my statement: USE PD51_Data; GO UPDATE CASENUMBERS SET CaseNumTypeID = 130 WHERE CaseNumTypeID = 101 AND CaseNumber BETWEEN 199999 AND 600001; GO I receive this error Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '9368----' to data type int. What did I forget Pig, What are the datatypes for the following columns: caseNumbers caseNumTypeId caseNumber My guess is that one of the fields -- maybe caseNumber -- is a varchar and contains the string '9368----'. Dave ...Show All

• Windows Forms Hosting Winform controls in IE6 crashes (only .net 2.0)

  HI ! I've hosted a Winform custom control derived directly from Control (or any other Control derived from that). Put it onto a simple htm page (or aspx), and when IE starts it up, IE crashes. The event log says Faulting application iexplore.exe, version 6.0.2900.2180, faulting module user32.dll, version 5.1.2600.2622, fault address 0x00010129. If the component is used on a machine with only .net 1.1 it works. If exactly the same component is used on a machine with .net 2.0 it crashes. It doesn't matter if the component is written in 1.1 or 2.0, the same thing happens. The relevant part of the htm page is as follows: < OBJECT id ="ListEx2" height ="100" width ="100" classid ="ht ...Show All

• Visual Studio Tools for Office COM Exception in CommandBars["Task Pane"].Visible = true

  I am getting this occasional COM error when trying to ensure that Document Task pane is visible: This code: Globals.ThisWorkbook.Application.CommandBars["Task Pane"].Visible = true; Causes this exception: System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component. at Microsoft.Office.Core.CommandBar.set_Visible(Boolean pvarfVisible) It seems to start failing when I open another work book in Excel and go back to my VSTO workbook. Should having additional open workbooks interfere with opening Task Pane Is there a reliable way to open or close task pane from my VSTO assembly ...Show All

• Software Development for Windows Vista Unable to create XPS doc with A5 pages

  I've been bashing my head against this on and off for days and finally accept defeat! How do you save or print items from an ItemsControl to an A5 page with a transform to fit the page I have 2 separate problems (I think):- 1) The XpsDocument ignores the PrintTicket and defaults to something like NorthAmericanLetter. 2) The items I'm trying to print are part of an existing visual tree. How can I scale and translate an item when writing it to the document without affecting what is currently rendered to the user This is the code I'm using:- public void SaveItems( ItemsControl ic, String fileName) { LocalPrintServer ps = new LocalPrintServer (); PrintQueue pq = ps.DefaultPrintQueue; // Set ...Show All

• SQL Server Stored Procedure Hang the first time, the run the send time.

  Hi! I have a Dayabase in SQL 2000 and then I moved it to SQL 2005. Everthing worked fine except one stored procedure. The first time I run the proc, it get hanged, and then I stop it, run again, it will run in a second perfectly. I guess there is something get locked the first time. Is anybody have any idea what is going on there I What kind tool can help me to debug this Thanks, Leshan Unfortunately, the proc will take more than one minute to run if I don't interrupt it. And the second time run did not get speed up as expected. If I close the connection, and open a new connection, the proc will run normally. But then the sencond time I run, hang,hang,... SO, I guess there is table lock issue over there.The proc update / ins ...Show All

• Software Development for Windows Vista SDK Platform Problem

  I am trying to get the SDK that lets you create Windows Forms Apps in VC++ 2005 Express, but I've ran into a problem. Im following the instructions here: http://msdn.microsoft.com/vstudio/express/visualc/usingpsdk/default.aspx I've run into a snag though. I can't seem to find the file: corewin_express.vsprops. I do have a file called corewin_express. I dont know if this is the same file or not. Well anyway, I continued along (changed the corewin_express file). I then try to make a windows forms app, but I get this: A norton antivirus pop up comes us and says: Malicious script detected High Risk Your computer is halted and needs to do someting about this script: Details: Object FileSystem Object Activity GetSpecialFolder File VCExp ...Show All

• Visual C# VS 2005: "Key not valid for use in specified state"

  Hi all- I'm running VS 2005 final release version.  I have a solution with two projects in it; an ASP.NET website in C# and a VB project which is my data access layer. Yesterday, this code was working fine.  I can compile and run the solution, and all the code works. But when I try to access or add a new datasource through the VS 2005 Data Sources Explorer, I get a popup which says: "An unexpected error has occurred.  Error message: key not valid for use in specified state." This message pops up after I select database as the source of my new datasource.  The wizard does NOT fail if I use a Web Service as my new datasource. Any ideas on what is happening, and how to clear up the problem ...Show All

• Visual Studio VS2005 Setup error: write space and enough space in dir

  When I try to install Visual Studio 2005 I get the error message: Some components must be installed in c:\Programme\Microsoft Visual Studio 8\ directory. Check that you have write permissions and enough disk space in that directory. My user has administrator rights on my WinXP SP2 machine and I have more than 100GB free space on drive C. Can anybody help me with this error message I had the same problem and this was my solution: First take a look at the logfiles: On my machine there is an errormessage " [07/12/06,14:55:45] VS70pgui: Invalid installation path: Component  Servicing Installation directory D:\" in the file c:\documents and settings\username\local settings\temp\dd_vsinstall ...Show All

• SQL Server The version of the linked, with the name of '', on the remote instance has changed. Repeat the operation to

  I am getting an error when accessing olap from excel. "Errors in OLAP storage engine. The version of the linked, with the name of '', on the remote instance has changed. Repeat the operation to resolve the issue." I have another thing, im using Linked measure groups. Like this table A Measures Actual Table B M. Budget Table B has writeback table that is used alot. I do on B the linked measure group of A. B's Writeback, doesnt contain A's measure Does anyone know what might be the problem and how to fix it Thanks What happens if you just re-submit the same query again Do you still get the same error or not Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights ...Show All

• SQL Server Silent install new SQL Express instance via MSI

  I'm currently building an MSI to install SQL Express and want to install as a new instance, not the default instance, and not into the SQLEXPRESS instance either. I saw the package.xml for Express in my VS Studio install. How would I go about using this Or would I have to modify the MSI via Orca or something I hope not. Wouldn't have a clue where to start. In short, regardless if there is already an SQL Express instance on the machine or not, I need to silently install a fresh new instance of the server engine only, no client tools except sqlcmd.exe I have seen that MS would advise that everyone use the SQLEXPRESS instance but I don't agree with it. I don't want other application installs trampling over my server settings and I do ...Show All

• Visual C# Interfaces oversold???

  First, I must admit that I am a C# novice and so I probably don’t have as much knowledge and experience on the subject of interface as most of you guys reading this post. After reading a few books on C# and interface design, I still can’t see and understand the real power of interface unless of course, we are talking about interfaces as a powerful concept in OOP ‘only’ and not as a powerful concept in the general sense. When I was first learning OOP I was quite suspicious about the ‘excellent features’ that OOP claims to be able to deliver to the world and I was right. For example, in reality OOP offers very little if any, code reuse. I am now having the same suspicion about interfaces even though I see a lot nice words used to d ...Show All

• Windows Forms change splitter color

  i am using the splitContainer and i want to change the color of the splitter there's not a proprety of backcolor the u have to say splitContainer.BackColor = System.Drawing.Color.red for example if u want to put the backcolor in red. I hope it was usefull yo u, byes ...Show All

• Visual Studio 2008 (Pre-release) WCF integration with GSOAP

  Hi, I’m trying to write a c++ client that talks to .net WCF server. For that aim I’m using the GSOAP application. I was successful in writing a c++ client that talks to an asp.net server, but when I tried to write c++ client and a WCF server they failed to interact. When the client sent a request to the server the following fault was received: Error 415 fault: SOAP-ENV:Server [no subcode] "HTTP Error" Detail: HTTP/1.1 415 Cannot process the message because the content type 'application/soap+xml; charset=utf-8' was not the expected type 'text/xml; charset=utf-8'. It looks like the WCF server doesn’t know how to deal with the format of the client requests. Does anybody know why this occurs Can I change the ...Show All

• Visual Basic Class Question

  if i create a class, eg. mask, which inherits from another, eg. general, if i put a constructor in the mask class, is it correct i need to copy the rest of the constructor from the general class. cos i thought i don't need to do this as i is inherited from the general one. Public Class General Private _firstOct As Integer Private _secOct As Integer Private _thirdOct As Integer Private _fourthOct As Integer ' CONSTRUCTORS Public Sub New () ... End Sub Public Sub New (ByVal one As Integer, ByVal ...) ... End Sub ... Public Class mask Inherits General Private _slashNotation As String Public Sub New (ByVal slashNotationVal As String) ... End Sub Public Sub New (ByVal one As Integer, ByVal two As Integer, ...Show All

• Windows Forms Inheriting the windows form from another windows form

  I'm trying to inherit one windows form (inheritForm) from another windows from (baseForm). I want to override the the baseForm's some events with the inheritForm events (let's day I want to override the form_click event). Can we really do this. I mean does the design of .net framework 2.0 support this If yes, it'd be gr8 if you can post few lines of code. Thanks, Vivek thank u sirjis. this is the second time am using this method for a project. There is no runtime error while using this method. but sometimes am getting this error Warning 1 The designer could not be shown for this file because none of the classes within it can be designed. The designer inspected the following classes in the f ...Show All