How to troubleshoot the COM Add-ins loading issues

1.         What is the unmanaged COM Add-ins loading process? Here is a COM Add-in registry example. [HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\AddIns\UnmanagedAddin.Connect] “FriendlyName”=”UnmanagedAddin” “Description”=”Composed in ATL 8.0” “LoadBehavior“=dword:00000003          HKEY_CURRENT_USER: this is user level COM-Addin          Excel: This is an Excel COM Addin          UnmanagedAddin.Connect: This is progid of the COM Add-in          LoadBehavior: control how the Add-in will be…

4

Manage database of ASP.NET 2.0 Membership & Role services in non-ASP.NET context

One question I’ve seen asked a few times by people in the NG is “how do I manage ASP.NET Membership, Role Management database in non-ASP.NET application/context”. This blog entry walks you though a few simple steps on how to-do this.   Quick Review: What are the new ASP.NET 2.0 membership & role management Services?  …

9

Use your ASP .NET WebControl in MOSS 2007 with Sharepoint Delegate Control

  In the new release of Sharepoint Server (MOSS 2007), a very interesting control is provided,  “DelegateControl”, under Microsoft.SharePoint.WebControls.SPControl. With this control we can easily reuse our ASP.NET control on SPS pages. Now, an ASP .NET programmer can name himself a “part time SPS Web part developer” Here is sample on how you can use…

14

Row Size limitation in SQL 2000 and 2005

  When you creating a table, you may encounter the following information: ‘ Table <table name> has been created but its maximum row size(11038) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE Of a row in this table will fail if the resulting row length exceeds 8060 bytes.   The reason…

6