John VB's Q&A profile

• SQL Server TRANSACTION

  Hi everyone, I have some doubts about Transact keywords. At the below snippet, transact is used for also error handling and as I understood that when the error occured in the transaction scope, the error is caught and then managed in a desired way. for instance, at the below snippet, the programmer catches and manages the error by first printing a message and then rooling back the execution(Stopping(ending) the execution).So can it be said that TRANSACTION is also used for ERROR HANDLING because of the above reasons BEGIN TRAN INSERT titles(title_id, title, type) VALUES (@title_id, @title, @title_type) IF (@@ERROR <> 0 ) BEGIN ...Show All

• Visual Studio Tools for Office Button is not getting removed after uninstalling the Word add-in

  Hi All, I'm creating and installing a Word Add-in. The add-in creates a button on standard toolbar. When I uninstall the add-in the button is not getting removed. The add-in is the basic add-in from the link http://support.microsoft.com/default.aspx scid=kb;en-us;Q302901 as it is. The code in OnBeginShutdown is as follows: public void OnBeginShutdown(ref System.Array custom) { object omissing = System.Reflection.Missing.Value ; System.Windows.Forms.MessageBox.Show("MyCOMAddin Add-in is unloading."); MyButton.Delete(omissing); MyButton = null; } Can anyone let me know what am I missing I've even tried using oCommand ...Show All

• SQL Server Anyone else finding this painful?

  Although I am sure I will grow to love this new product I can honestly say that everyday has been a painful experience. Most of this, once again, is the learning curve to the new product. Moreover, each accomplishment leaves us feeling as if we are doing things the wrong way. Here is an example... We are populating lookup tables from a staging environment. This is pretty straight forward, insert records that don't already exist in the destination. Unfortunately, the only way we could get this to work properly, outside of just writing T-SQL for everything, was to use a lookup transformation and redirect the error rows into the table. Altho ...Show All

• Visual Studio Team System Is RTM supported by latest online Installation Guide?

  I've downloaded the latest Team Foundation installation guide from: http://www.microsoft.com/downloads/details.aspx familyid=E54BF6FF-026B-43A4-ADE4-A690388F310E&displaylang=en (File TFSInstall-v60317.chm) Here is a quote from the "Start Here to Upgrade" section: " To upgrade from Beta 3 Refresh to the release candidate, download the upgrade package from the Microsoft Downloads Center ( http://go.microsoft.com/fwlink/ LinkID=60341 ) and follow the upgrade instructions for Team Foundation servers. For new installations, follow the instructions in this guide." Note how it talks about the "release candidate ...Show All

• Visual Studio Unable to debug System.Net.DigestClient throws an exception

  I converted a VS2003 application to a VS2005 application. I have no errors and no warnings when I compile. When I attempt to run I get the error:   Unable to start debugging on the web server. The type initializer for 'System.Net.DigestClinet' threw an exception. Any thoughts on how to fix this I am assuming this is an IIS web application. Is this correct Do you have the same problem for all web applications Do you have the same problem on all computers ...Show All

• Visual Studio Team System WorkItem queries with joins to other linked work items?

  Does anyone have any examples of work item queries that join linked work items In code it can be done by using a workitem query to populate a workitem store, then getting the link ids by looping, i.e. Dim wiqlQuery As String = _ "Select ID " + _ "where " + _ "([System.WorkItemType] = 'Deploy' and " + _ "[MySystem.Deploy.Target] = 'TestSystem5' " + _ "and [System.State] = 'AuthorisedToProceed') " Dim workitems As WorkItemCollection = store.Query(wiqlQuery) For Each workItem In workitems For Each l In workItem.Links 'gather the ids into a string...eg..('100','104','103') N ...Show All

• Visual Studio Tools for Office ListOject Displaying updates on Excel have event problem

  Hi,    I'm having a ListObject in Excel and is binding it to data in a DataTable via: list.DataSource = dt_myData;      The data is changed periodically via a separate thread running in the background (not via BackgroundWorker method) and the data displayed does change when I rerun the above code.    The problem occurs when I'm editing another cell outside this listobject and the refresh occurs.  When I run the above again after the I have finished editing any cell, the display of the data does not change.  This seems to be breaking the updating Event process. & ...Show All

• Windows Forms TreeVeiw problem

  Hi, I have a UserControl that contains a TreeView(with nodes) , a TextBox and a Button, I want that when you click on the button you would add a new TreeNode under the selected node that it's name is the text of the TextBox. I have tryed a lot but no success, I need som code, thanks Hi, in the designer double click on the button to add an onclick event handler, then in that handler function create a treenode and add it under the selected node: TreeNode newTreeNode = new TreeNode(); newTreeNode.Text = "Hi"; // let's check if we have a selected node if (treeView.SelectedNode != null) // yes we ...Show All

• Smart Device Development New to .Net CF2 & PPC programming.

  Howdy! I've done a bit of programming in the past and now am looking at making some stuff for PPCs. I downloaded the Emulator and ActiveSync, but have not managed to get them to sync together. Anyone know of any n00b guides for this I read in the doco to 'rightclick on the GUID'. I'm guessing this means 'rightclick on the emulator' but that brings up no menu for me. I'd also like suggestions on a free IDE and compiler. I'm thinking .Net Compact Framework 2 is the place for me to start. I'm not really a guru in any language altho I've programmed a handheld game in C (with a little C++ thrown in) and a small very simple application in J2ME. I ...Show All

• Smart Device Development Performance issues - Direct 3D Mobile

  Over the last couple of days I've been looking at Direct 3D Mobile but I must say that I am a bit disappointed on the performance. I've been running some of the samples located on msdn2.microsoft.com and the frame rate is real low. When running the Fixed Point Math Lightning example (having removed both walls AND the animated mesh) I get a framerate at about 0.32 both in the emulator and on the real device. I get about the same framerate when I run the sample on the PPC WM5 Emu. Does anyone know if it's supposed to be this way Is it a bug in the framework A bad setting in the device If I run a project which ONLY clears t ...Show All

• Visual Studio 2008 (Pre-release) When and where to set custom IIdentity when implementing custom authentication

  Hi - If custom user name/password authentication is being implemented, where is it possible/recommended to set the "PrincipalIdentity" to a custom IIdentity object So far I have custom implementations of ServiceCredentials, UserNameSecurityTokenAuthenticator, UserNameSecurityToken and IAuthorizationPolicy all hooked in and working nicely to verify user credentials against a custom store. I am looking to attach a custom principal object following the example in this thread . However, the object obtained from EvaluationContext.Properties["PrimaryIdentity"] when IAuthorizationPolicy.Evaluate gets called is a GenericIdentity. Where should I (ca ...Show All

• Microsoft ISV Community Center Forums Runtime error '-2147467259(80004005)';

  Hi, Iam using vb6.0 and database is PostgreSQL,when iam trying to connect database using Connection String iam getting error like this Runtime Error '-2147467259(80004005)'; Could not connect to the server Could not reslove hostname. ********************************************************************************* can anybody slove this Per the support engineer: Is there a native OLEDB provider for PostgreSQL that you could try instead of ODBC If so, You would try that first. > SERVER=localhost;DATABASE=SIC;UID=sa;PWD=**********;Socket=4096" You should not use your s ...Show All

• Visual Studio Crystal Report in VS 2005

  have developed apps. with VS 5 pro and VS 2003 pro. include using crystal reports. But I'm considering upgrading to VS 2005. I recently got the trial version aftering using the beta 2. I love the easy of coding in '05' and database connections. My problems has been in the crystal reports. Remember I have used cystal reports with the older versions (I'm no pro but okay with it). They work well in the other platforms that I own but this version '05' it don't seem to work or maybe I'm not doing something right. I even tried to use the other Report feature now included in '05' it does not work either. I'm not doing anything great or different fr ...Show All

• Visual Studio Tools for Office VSTO - Outlook - Unload addin

  I have written an addin for Outlook 2003 using VS.net 2005, VSTO, and C#. In " ThisApplication_Startup" I perform several tests to see if the addin should load for the current user. If the addin should not load, how do I unload the addin without shutting down outlook I keep seeing things that say you can shut down the addin's app domain, but I have not seen code that says how to get the addin's app domain. If this is how you are supposed to do it could someone give me a code snippet to accomplish this If there is a better way could someone please let me know what it is Thank you very much Kelly Johnson ...Show All

• Smart Device Development remote code profiler - can't resolve functions name

  I'm using the remote code profiler with evc4. I compiled my application with the /callcap option and added the cecap.lib to the linker. Profiling works fine, but it doesn't resolve the functions name. I'm compiling with the release configuration, so debug information is not available in the executabl, however, I have generated a pdb file which resides in the same directory and name of my executable. Still, I don't get function names resolved. Anyone can help Thanks. Hello,      There are a number of scenario's where the remote call profile is known not to resolve function names proper ...Show All