prk's Q&A profile

• Gadgets Managed COM object not unloading in Sidebar

  So I created an ActiveX control in C#. Works great except for one problem, it doesn't unload when the gadget is closed. I thought it might be something in my gadget that was causing the problem, but I created a gadget that has nothing in it, and it doesn't unload either when the gadget is closed. I tried the same thing with an ATL C++ control, it unloaded fine when the gadget was closed. Any ideas, it's really a problem when installing a new version over an old version thats been run at some point in the sidebar's process time. Dan O'Connell Try clearing the object as the Gadget closes. If the COM has any dependencies that you need to clear down, add a terminate function to the COM to clean ...Show All

• SQL Server sql 7.0 delayed trigger

  HI all, I have a trigger that i need to run after the insertion or update is done. I know there is a code that on 2000 saying after but 7.0 doesnt have that. How can i do this on 7.0 It is the same as an AFTER trigger in SQL Server 2000 yes - but on both versions an after trigger is not truly after, it is more like right at the end. The trigger runs before the transaction is committed so that it can roll the transaction back if necessary. You need to use the inserted and deleted tables to see what the rows that are being inserted and deleted are (for an INSERT trigger the inserted table holds the new rows that are being inserted - they are not in the table yet, for an UPDATE trigger the deleted table holds the rows that will be upda ...Show All

• Internet Explorer Development IE7 and Right Click Menu

  I have an IE explorer bar which makes use of a Right Click menu option. The right click menu option is implemented the usual way by creating a new key under HKCU\Software\Microsoft\Internet Explorer\MenuExt\<menu text> and this menu is pointing to a file in the local file system. This file is basically a VB Script file which parses the highlighted text passed down to it from the browser and uses that text as a query parameter to lauch another URL from the server (using external.menuArguments.navigate(url)). My Explorer Bar captures this navigation, stops it in the main browser and relaunches it using IWebBrowser2.Navigate so that the URL will show up inside my Explorer Bar rather than the main browser window. Eventually this new URL ...Show All

• Community Chat Dynamic Semantics of Document

  Hi, Few days ago, I read some articles about MSOffice 2007, and I was puzzled with the term: Dynamic Semantics of Document. Can anybody explain the term: Dynamic Semantics of Document in MSOffice. Is there any tutorial or material about this topic Thank you in advance! ...Show All

• SQL Server Performance problems with SQL commands in data flow task

  SQL statement within an OLE DB Command component is extremely slow (hours, days). Same SQL statement executed within a query window of SQL Server Management Studio takes only a few seconds. Using a fairly simple SQL UPDATE statement against a table with only 21,000 rows. Query: UPDATE Pearson_Load SET Process_Flag = 'E', Error_Msg = 'Error: Missing address elements Address_Line_1, City, and/or State' WHERE (Address_Line_1 = ' ' OR City = ' ' OR State = ' ') AND Process_Flag = ' ' Any suggestions on how to improve the performance of this task or an alternate solution are appreciated. Thank you. Jamie, Yes, I did solve this using an Execute SQL Task. It was a rather straightforward so ...Show All

• Visual Studio Express Editions Copy files from FTP to Harddrive

  Hi. I have code which downloads a file from my FTP space onto my hardrive. Can somebody help me to incorporate a loop so it downloads every file in the FTP dir, and puts them in the HD. So it downloads every file in ftp://ftp..../pub/myprogram and puts them in C:/myprogram. This is the code i have for 1 file: Imports System.Collections.Generic Imports Utilities.FTP Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Values to use Const localFile As String = "C:\myprogram/blah.exe" Const remoteFile As String = "/pub/myprogram/blah.exe" Const host As String = "ftp://ftp.invision.ecwhost.com" Const username As String = & ...Show All

• Windows Forms Sending email in vb.net 2005(using vb) not with smtp but the users outlook (mapi)??

  I have an application that I need to send mulitiple emails from. There are about 10 users who will have permission. However my IT Group has locked down the smtp server and will not allow "Applications" use the smtp method. I remember in vb6 I used mapi to send emails using outlook that was on the users computer thus giving my IT folks traceability of who is sending what and not having to set up 10 people on the smtp permissions. Can this still be done using outlook(mapi) they are only allowing server to relay email, no desktops will be allowed to send relay email. I did a project a few years ago where I used mapi in vb6 to send email and it was using their outlook not the smtp ser ...Show All

• Visual Studio 2008 (Pre-release) Infinite timout on http-bindings

  I have an application that hosts a WS using basicHttpBinding. The client calls a method which returns an object. The problem is that the method may take time and won't return anything until the binding has timed out. Is it possible to have an infinite time out (probably not feasable) or is there another way to solve this Another option you have is to use async methods. The Begin method would return right away, and whenever the result is ready the callback would be invoked. More information at the asynchronous sample at http://msdn2.microsoft.com/en-us/library/ms751505.aspx . And yet another option would be to use a duplex contract, where you'd make an one-way call to the method (which would return righ ...Show All

• Visual Studio 2008 (Pre-release) Can i debug the service developed using WCF.

  hi, I want to debug the service that has been developed using WCF. When i inovke a method exposed thru a service i need to debug from the client to the service. Both me client and service are on the same machine. Is it possible to debug Thanks in advance. Regards, Rajesh. Any Idea how to debug wcf service build via the webservice software factory. I can't seem to get it to step into the actual source of the service... ...Show All

• Visual Studio VS.NET C++ Debugger no longer loads DLL symbols when we attach to the host process.

  We've notice a problem recently whereby attaching the debugger to our host process no longer allows us to debug our DLLs. Repro: set a breakpoint in DLL then go to Debug-menu->Processes and attach to the host process. Result: the DLL's breakpoint is now shown with a ' ' (question mark) in it, indicating that the symbols were not loaded. This used to work OK, so we are wondering: what has changed Also, how do we fix this Hi, The PDB file has to match up with the DLL, otherwise VS will not load the PDB. This means that if you re-built the DLL and deployed it but didn't copy over the new PDB it will not load. Any post-processing of DLL after the build could cause it not to be loaded for t ...Show All

• Visual Studio Team System Running the load agent at remote sites

  Hi, I'm currently evaluating Visual Studio Tester edition and have a question about licensing. Quite often I need to run load tests at client sites on their hardware. If I get a couple load test agents, can I uninstall from my local setup and install at client sites for testing Thanks, Cliff Hi Cliff, This and other questions you might have about licensing should be answered in our Microsoft Visual Studio 2005 Team System Licensing White Paper. http://www.microsoft.com/downloads/details.aspx familyid=1FA86E00-F0A3-4290-9DA9-6E0378A3A3C5&displaylang=en Thanks, David Gorena Elizondo [MSFT] VSTS ...Show All

• Smart Device Development FTP NLST From WM5 to UNIX

  I use th FTP example from Microsoft (kbms-help://MS.VSCC.v80/MS.MSDN.v80/MS.KB.v10.en/enu_kbvbnetkb/vbnetkb/832679.htm)and it connect but in the GetFileList function when reach to line: bytes = cSocket.Receive(m_aBuffer, m_aBuffer.Length, 0) it doesn’t return. It works fine with PPC30 and with WM5 when I connected to my Windows XP with ActiveSync. But when I connected via modem with UNIX it only works with PPC30 and I need the application for the news WM5 PDAs and for the PPC30 also. Can somebody help me with this issue. I am not that familiar with the code in that sample, but I wonder if there is a reason why you don't use the System.Net.FtpWebRequest class to handle the FTP protocol for yo ...Show All

• SQL Server SQL Server Compact Edition is not in the list of DataSources

  Hi everyone, I am using VS2005, just installed SP1, and the help -> about window reflects this. I have also installed the SQL Server Compact Edition SDK, but when i try to add a new data source connection (following the MANY tutorials on this), i do not see an option for SQL Server Compact Edition nor do i see an option for SQL Server Mobile. I am at my wits end and i just got started! Yikes... Any thoughts on how to proceed The only thing I see that I don't have but I might need is Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 Service Pack 1  http://www.microsoft.com/downloads/details.aspx FamilyId=877C0ADC-0347-4A47-B842-58FB71D159AC&displaylang=en  However, when i try to install that, i im ...Show All

• Visual Studio Team System Hi

  I have created a test run it and it worked ok. Then I copy it to a map drive and run it from there and I got an error saying the map drive is not trusted. I then added the map drive to the trusted zoons in the IE and run the test again and I got the following error "UTA052: TestingFrameWork.UnitTestInitializing is not a test class" Please help me. Right. We've already figured this out. The real problem is the "Assembly.TestClass is not a test class" error. ...Show All

• SQL Server Can't copy the .mdf file in an app because it's being used by another process

  Hi guys, I'm trying to copy database files along with a c# app to a backup store, & I get the error in the subject line even when I've detached it from sql server. Now, even in the application, if I try to detach it or delete it, it gives the same error. I'm really new at this, so any help would be greatly appreciated! Kimmy Hi OJ, I've been busy with other issues and just now have a chance to try what you suggested. I will do it now. Yes, I'm using vs2005. Good info to know about the user instance. Thanks, Kim ...Show All