The primary reason for writing this article is I've managed to make exactly the same mistake on two separate occasions. A third time would be careless...

For this particular recipe you need:

• A .NET application that uses COM interop (any should do but I'm using SQLServer DSO)
• A Visual Studio installer project

First add the output of your COM interop project to the installer project and, as if my magic, the COM DLL that your interop is using will be added to the installer. Next build your solution and install your new application. Then spend a couple of hours trying to work out why nothing works and you get strange error messages like "Could not find msmdso.rll" whenever the COM object is instantiated. This is especially difficult if your application happens to be running as a service and COM DLL displays the message in a message box (hint: listen for the unmistakable "ding" of the message box sound).

What has happened? Well when the COM DLL was automatically detected and added to the installer project it was flagged as "vsdrfCOMSelfReg" which causes the new copy of the DLL to registered at install time zapping the original COM registration. As for the message box, nothing you can do if it's DSO like mine unless you happen to work for Microsoft.

For some reason setting the flag back to "vsdrfDoNotRegister" still causes issues and the best approach is to set the "Exclude" property to true and completely remove the DLL from the installer.

One last tip. If you manage to do this with DSO then you can avoid reinstalling Analysis Server by executing the following:

cd "C:\Program Files\Common Files\Microsoft Shared\DSO"
for %i in (*.dll) do regsvr32 %i

There are quite a number of Exony bloggers and on average a new one starts each week. This is great for the bloggers and great for the company but I've noticed that the first couple of articles usually contain content thats a little too "open". As we don't yet have a corporate blogging policy I would suggest that new bloggers bear the following points in mind:

• Anything that's on the internet is public and the correct Google search can find what you've written in a second.
• Don't talk about new features until they are announced publicly. Even Microsoft bloggers are completely silent until a formal announcement has been made - we didn't hear about Visual Studio Team System until the Tech-Ed announcement, nor did we hear about the Express Editions until Tech-Ed Europe.
• Strategy and road-maps are best left to the marketing team.
• Once a feature is out in the open (e.g. press release) blogging about it is probably good publicity but be aware that your words can be twisted by unscrupulous people. Write carefully.
• Prospective customers might use your blog to decide on a purchase. If you write badly with spelling mistakes and poor content then they are likely to assume the whole company is run the same way.
• Exony is valued on it's IPR. Don't give it away.
• You are running a community - your readers. Treat them with respect.
• Full text feeds please. I don't generally read anything that can't be downloaded to my aggregator and read off-line.
• Linking is good. What better way to show us what you're reading? It brings relevant content together and provides a better picture.
• If in doubt, I'll be happy to take a look at your draft before you post it.

For additional guidelines, I recommend the Sun Policy on Public Discourse.

I've been really busy with work lately which means no time to investigate bloggable things. It's a shame because I'm doing some really interesting work with Excel, Web Services and OLAP. Maybe when it's released I'll be able to find something that doesn't give away Exony IPR.

In the meantime, I was trying to remember a time when I had nothing to do. Not just work wise - I have a permanent backlog of things I want to look into or code up. New API's, new technologies, new techniques, new books are all stacking up. Add that to the Golf Web Application I'm writing and the 200+ feeds I'm subscribed to and I think I have enough to keep me busy for the foreseeable future. I think I have a solution though - apply Scrum techniques. The backlog of things is large but the priority of individual items varies depending on an number of external forces. Sometimes they may no longer be relevant when I get around to doing them. I constantly re-prioritise anyway but having a sprint goal will help give a measure of progress and avoid being overwhelmed by the full list. Four weeks is too long for a personal process so I'll start with a single week at a time and see how things go.

As a separate note, why is Halo 2 being released in the UK two days after the US? We Brits are going to have to listen to the Yanks harping on about it for a full 48 hours - torture!

Koan has written an excellent article about Microsoft PSS entitled "A Bug's Life (or, how to get a hotfix out of Microsoft Product Support Services)". It's long but well worth reading.

I hear there is a nasty case of flu around at the moment which is likely to hit the UK by 11th November. It's unofficially being called "Covenant Flu". If you catch it then wrap up warm and don't leave the house until the symptoms have disappeared.

I've spent this evening working on the web pages for the GolfWeb application. Compared to the code I'm finding it somewhat difficult. Probably because web design is not one of my strong points. To make it doubly hard I've decided to complete the task without using any of the traditional table style layouts.

There are plenty of CSS resources on the web to help with the layout and effect you want but to tell the truth it's like learning a new language. The syntax is easy to pick up but, unless you know the language idioms, things don't flow and everything becomes disjoint. I guess the only way to learn is by doing so I'll have to persevere until things get easier. I don't suppose there's a CSS Cookbook available?

The autumn TV schedules are causing me a bit of a headache. Do I watch Hex or Carnivàle, The West Wing or Stargate Atlantis (or Champions League Football), Long Way Around or Spooks? The TV companies are really battling for viewing figures this season. Something has to give...

It's time to turn to toys. I need some sort of hard disk recorder that can record the programmes that clash. As I have a Sky subscription, it's a bit of a no-brainer, it has to be a Sky+ box. They have also just released a new version with 160GB (80 hrs) storage and a subscription deal that makes it only £150 more expensive than the standard model.

A couple of clicks on a web site, Google AutoFill for the credit card details and it'll be here next Friday. Sweet.

Microsoft has decided to delay the release of SQL Server 2005 from the first half of 2005 until later in the summer of that year. A Community Technical Preview will be released as an interim beta with possibly more to come before the final beta and the product’s eventual release.

(via The ServerSide.NET)

I guess my previous post was correct in it's assumptions. The SQL Server delay has allowed the Visual Studio team time to add C# Edit & Continue.