Skip to main content

Posts

SQL Server 2008 - Performance Counter Registry Hive Consistency Failed Error

If you ever get the following error during installation of SQLServer 2008 and wonder how to proceed. Let me help you out. You need to execute the following command in elevated command prompt to repair the registry from backup lodctr /R command from C:\windows\system32 directory and lodctr /R command from C:\windows\sysWOW64 directory (if running on a 64 bit OS) Hope this helps Regards Hitesh

Office 2007 Sequencing Recipe

Hello, I had a tough time sequencing office 2007 ( http://support.microsoft.com/kb/939796 ) as i am new to sequencing and faced one issue that seemed difficult to solve. After launching Microsoft Word i got the following error "2007 Microsoft Office System - Please wait while setup prepares the necessary files." "Windows Installer - Preparing to Install" I found a KB article which explained exactly what i need to do http://support.microsoft.com/kb/928091 Here is an extract which i followed to eliminate the error To bypass the auto-registration for Word 2007, follow these steps: Exit Word 2007. Start Registry Editor. In Windows Vista, click Start Collapse this image Expand this image , type regedit in the Start Search box, and then press ENTER. Collapse this image Expand this image If you are prompted for an administrator password or for a confirmation, type the password, or click Continue . In Windows XP, click Start , click Run , typ...

Calling a .NET DLL Function from VBA

Recently i had to call .NET code from my VBA Macro in order to do something not available out of the box using VBA. i searched a lot of content on the web and found this wonderful web page http://www.geeksengine.com/article/create-dll.html The article clearly explains how to create a dll and reference it in VBA. There were a some issues I hit upon while following the instructions mentioned in the link 1. In my code I had the following line of code     Set f1 = New myplugin.Class1 The VBA compiler complained invalid use of New Keyword. I then modified my code to the following based on a colleague's suggestion Set f1 = CreateObject("myplugin.Class1") and then it worked fine. 2. On trying to create an instance of the .NET class in my VBA code When distributing the dll by using following link, I hit upon an issue http://www.geeksengine.com/article/register-dll.html I was getting the following error on target machines RegAsm: error RA0000...

Introduction to AJAX

Asynchronous Javascript (AJAX) technology enables web applications to provide features like- Partial Page Updates - Allows you to define an area of a webpage to postback and update independently from the rest of the page. Only the updated content is refreshed when the request completes Indicate Progress of an operation - This allows you to track progress of server-side process and continuously update the user. Desktop-like UI - With AJAX, you can provide users with controls such as modal dialog boxes, progress indicators, masked edit bixes, tooltips and more. Cross Browser, cross platform support - Javascript, AJAX and JQuery are all supported on multiple browsers and multiple platforms. Every ASP.NET page that uses AJAX must have one and only one ScriptManager class which enables- Registration of custom scripts Registration of web service method calls from client Since you can use only one instance of ScriptManager class in an ASP.NET page there is a ne...

Visual Studio Tools for Office (VSTO)-Introduction

This blog post is an extract of VSTO for Dummies. VSTO isn' t a replacement technology for Visual Basic for Applications (VBA). VSTO is a set of tools that you can use with Visual Studio to supercharge Office. Put simply, VSTO offers tools to - 1. Build add-ins 2. Build customised documents for Office Applications like Word and Excel. Add your custom functionality to existing Office applications, via add-ins. Leverage all the existing Office functionality in your applications, like Word document layout and Excel formulas, through communicating with those add-ins Make documents that integrate fully with existing applications and databases Use Microsoft SharePoint to increase communications between knowledge workers with add-ins and documents that communicate. At their core, Customized Documents are document-level only, while add-ins are application-level and can apply to all documents used by that installation of Office. Four important features are availabl...

A document opens in read mode in office 2010 but in edit mode in office 2007 when using sharepoint 2007

Some compatibility issues can be observed when using Office 2010 with Sharepoint 2007 1)Word documents open in read mode when selecting the document link in sharepoint (not using dropdown menu). The behavior in Office 2007 was documents would open in edit mode. To open word docs in edit mode using office 2010 and SharePoint 2007 one needs to use the dropdown menu 2) Excel files, when selecting the document link (not the dropdown menu), are requiring a refresh before changes can be saved. Any merges of data are lost during the refresh. The refresh error/warning is a compat issue between office 2010 and SharePoint 2007.

ASP.NET 4.5 , Visual Studio 2011 Developer Preview is here! Also an update on Denali!

Hi, The next version of ASP.NET is here for a developer preview. You can read more about it and watch videos at the following link http://www.asp.net/vnext To know more on whats new in this release you can refer the following link http://www.asp.net/vnext/whats-new Be sure to also visit the following link to understand whats new in Visual Studio 2011 http://msdn.microsoft.com/en-us/library/bb386063(VS.110).aspx Coming to SQL Server 2011 (code named Denali) there is an update on one of its projects named juneau- You can read about this here - http://msdn.microsoft.com/en-us/magazine/hh394146.aspx Developer's first reactions to the Visual Studio 2011 Preview can be read here- http://www.infoworld.com/d/application-development/visual-studio-2011-developers-first-reactions-176797 Happy Reading