Linda Call's Q&A profile

• Visual Studio Are there any examples online for creating Server Explorer like ToolWindows?

  I'd like to replicate the functionality of the server explorer in another toolwindow, ideally the tree view functionality of the servers but other parts as well. Are there any good examples out there that go over this Hi Ed, Could you post your code somewhere else GotDotNet has been phased out and I couldn't access it. Thanks a lot! Yueming ...Show All

• Visual Studio Express Editions making it count

  hi trying to make a label count upwards. what have I forgot Dim tries As Integer = +1 Label10.Text = tries.ToString Hi. Something like this should solve your problem. Dim counter As Integer = 0 While counter <= 10 msgbox(counter) counter += 1 End While Best regards. dp ...Show All

• SQL Server check version of sql 2005

  how do i check whether i have installed 64 bit /32 bit sql server 2005... if i see Program files and Program files (x86) directory can i be sure... one more query..Is windows 2003 enterprise edition 64 bit Itanium based operating systems Thanks in advance Is this really a SSIS question or the SQL engine The standard SELECT/PRINT @@VERSION command works here for the SQL engine, just look in the output for x64 vs x86, or Itanium I presume, but cannot confirm, e.g. Microsoft SQL Server 2005 - 9.00.2153.00 (X64) Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1) The presence of the Program Files (x86) directory means you ...Show All

• SQL Server Getting Previous Date SQL Script

  Hello, I have a table that also has a timestamp field I want to get any data that was inserted into that table on the previous day even if the month changes and i have no clue how to go about that Tdar SELECT * FROM yourDatesTable WHERE DATEDIFF ( day , yourDateColumn , getdate ())= 1 ...Show All

• .NET Development Problems with enabling/disabling Services in Microsoft Management Console!

  I'm getting the following error message: WBEM error features not available. Upgrade WMI to a newer build. How do I do this This is not related to managed networking APIs. Please refer to other forums/usegroups at http://www.microsoft.com/communities ...Show All

• Gadgets Dll Won't register

  I wrote a gadget that uses a C++ dll as an ActiveX object. The dll was written in VS2005 on an XP pro machine using Bruce Williams tutorial as a guide. It registers fine in XP (using regsvr32 and manually registering it in my gadget) and when I open my gadget.html in IE it works as it should. When I move the gadget over to my shiny new vista machine (Business edition) the DLL can't register. I can write the appropriate values to HKCU manually in the gadget, but it still gives me an error when I try to create the ActiveX object containing my class and regsvr32 gives me errors about the side-by-side configuration. I've tried it as both administrator and standard user. Does anyone have any insight about how to register my DLL Thanks ...Show All

• SQL Server OpenQuery With Large String?

  Hi, I declare a variable @MdxSyntax as NVARCHAR(4000) to store MDX OpenQuery syntax on Store Procedure. SET @mdxSyntax = ' SELECT * INTO ##BU01505100 FROM OPENQUERY (MOJOLAP, '' WITH '') ' EXEC sp_executesql @mdxSyntax But maybe the syntax too long, system response syntax unclosed! So, I change @MdxSyntax as NVARCHAR(MAX), but it still response syntax unclosed. Why It's the limit of OpenQuery or MDX Thanks for help! ManiD, Thanks for your reply! But my point is no matter what I declare @mdxSyntax as NVARCHAR(4000) or NVARCHAR(MAX) , the query result always response syntax unclosed . WHY ...Show All

• Visual Studio Automate component installation in toolbox?

  Hi all! I'm trying to create a simple program that installs some components into VisualStudio2005 toolbox (adding a new tab and some components). The code below works fine BUT for some reason the MyComponent.dll file gets locked by VisualStudio after the installation. I can't delete the MyComponent.dll file (not even manually from the file explorer). If I close VisualStudio the file is not locked anymore. Anyone got a clue of how to make VisualStudio let go of my file after installation public partial class MyInstaller: Form { private string currentDir = Environment.CurrentDirectory + "\\"; // Constructor public MyInstaller() { InitializeComponent(); } // On "Install" button click private void buttonInstal ...Show All

• .NET Development Why Tables.Rows.Count is 0 even though rows are displayed in DataGrid

  1. I have a webforms application. 2. I am checking the number of rows is higher than 0 if (DataSet1.Tables(0).Rows.Count() > 0) 3. The value is always 0 even though I have retrieved rows from this DataTable into my DataGrid. Any Ideas Please help.. I may have the answer, but I may be wrong. To me I see two places. One, should you use square brackets for the index search Also, it seems like you are using a property as a function and should remove the round brackets after Count. Ex; if(DataSet1.Tables[0].Rows.Count > 0) ...Show All

• Visual Studio 2008 (Pre-release) Custom transport - protocol transport

  Hi, I'm trying to understand the building blocks that go into a custom transport. For my specific scenario I need to build a custom TCP transport to support different message framing scenarios. However, I was wondering where one would implement high level protocol logic. For example, let's say you have simple text messages like: LOGON| REQUESTSOMETHING| HEARTBEAT| etc. Now, for example the client sends REQUESTSOMETHING| before a LOGON| thus you need to reject the message and every x seconds you want to send a HEARTBEAT| .. etc... where would this session logic be implemented Thanks, Tom Tom Also check out the WSE 3.0 TCP Interop sample here: http://wcf.netfx3.com/content/BuildingCustomChannels.aspx - ...Show All

• Visual C++ Interaction with an application running in CMD

  Hi all, I have written code for an appliation which needs to interact with another application which runs in CMD. I want to receive all the information produced by the application running in CMD so that I can manipulate them and at the same time I should be able to provide input to that application. Please suggest me somehting regarding this. Thanks, From application B's perspective, it is getting its input via stdin, as if the user were typing it via the command line. Application B still writes to stdout, and application A can read it from the other end of the pipe, also a file descriptor. I think I got this idea. And the way you have mentioned it, it's exactly the same thing I want to do. I will try this example for my purpose ...Show All

• SQL Server Changing destination database for SSIS Package

  Hi, I have a small problem. I've gone through the SSIS wizard and created a dtsx file which imports data from an access file into a SQL Server 2005 database. It has been set to delete existing rows and enable identity insert. I then edited the .dtsx package in SQL Server Management Studio and added an environment variable configuration to allow me to change the destination database. In the script which runs the dtsx, here is what I have (it's an x64 system, so hi have to use DTExec): "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /file e:\testimport.dtsx /set \Package.Connections[DestinationConnectionOLEDB].Properties[InitialCatalog];newdatabasename and here is the error I get: Description: T ...Show All

• SQL Server This is not good, heads(mine) are gonna roll

  The package is corrupt, who knows why, who knows what. It was running fine but there was a bug in an active script. Having failed miserably to debug this (note the ability to put a breakpoint in a script would be nice and dear god do not ask for edit and continue in here, it is bad enough as it is!) i eventually stuck a ref to the winforms namespace and debugged with a hundred messagebox.show statements. I did try to fire up an event that would write to an event tlog and i'm pretty sure that that is where the main problem lies as the package is still trying to load/use/connect to some log options but it did run for a while after i abandoned this path. Either way, I need some clue as to what bits of the xml file i can hack cos that is all i ...Show All

• SQL Server get dates NOT between x and y

  Hi. I hope this is the write place to post this, I hope it is. basically, I want to be able to return me a query of giving me available dates in a table. What I mean is that, if I have a table with fields including start date and end date, I want to return me the dates which are NOT listed/stored in the table. kind of like a booking system, where you store the room reservation dates and obviously you don't want to double book that room, so I would like all the available dates to be returned back. is this possible how can I go about doing this Thanks! Edited! you know, i realize , I too have difficulty getting date these days. use northwind declare @begindate datetime,@enddate datetime ...Show All

• Visual C++ DLL constructors, easy question, please help, sample code provided

  Hi !      ...Show All