系统自动更新后IE6只要打开Office文件就崩溃

我们公司的电脑都会通过SMS自动更新.结果前几天系统自动打过一个补丁以后，再也不能打开SharePoint上的文件了。总是报告"An unhandled exception occurred in IEXPLORE.EXE[616]。我卸载了所有那一天的补丁，又找系统组的同事，结果依旧。

开始以为所有的电脑都会受影响，后来发现就只有我们几个同事安装了Office 2003 和Office 2007的有问题，即使只是安装了MS Office 2007 Compatibility Pack也有问题。他们把Office 2007卸载果然就好了。

但我想找出来为什么，在这里终于找到了解决办法：

Start

Programs

Microsoft Office

Microsoft Office Tools

Run Microsoft Office Diagnostics.

This application found an error and corrected it. Sharepoint files now all open fine.

在另外一个blog中有更详细的说明，

The problem happens when you have, or had, two versions of office installed. You have to go into your program files directory and delete the version of owssupp.dll you're not using (for example if you upgraded to office 2007 and then downgraded back to office 2003 you delete owssupp.dll in the office12 directory). IE 7's manage addons you can see two versions of the owssupp dll registered so IE gets confused and you have to forcefully remove the version you're not using anymore.

Make Ankh work within Visual Studio .Net 2005

It used to work but not these days. The installation itself was always smooth. But there was no context menu for Ankh.  

 

Finally I realized why. It seems Ankh needs to have a solution file. If I open a web site, it won’t work. So what I did was to save it as a solution then open it. Now peace is coming back.

How to open a window in full screen mode with Javascript

In one of our applications we need to open a window in full screen mode then close the launching window automatically. Here is what I googled.

1. To open in full screen (tests passed on IE 6.0, 7.0, but Firefox doesn't support it at all)
var newWin = window.open('NewWindow.aspx','fullscreen','fullscreen,scrollbars');

2. To close the launching window without a warning message
newWin.focus();
window.open('','_parent','');
window.close();

And if full screen is not allowed by users, e.g. IE 6.0 SP2 (link), we can set the window to take the maximum possible client screen with following code,
var newWin = window.open('Main2.aspx', '',
'toolbar=no,menubar=no,titlebar=no,directories=no,
location=no,resizable=yes,status=no,fullscreen=no,
top=0,left=0,width=900,height=700');
newWin.moveTo(0,0);
newWin.resizeTo(screen.availWidth,screen.availHeight);\

However, there is a known issue. IE 7.0 will always display the address bar in the above window due to phishing detection concern. And Firefox is considering to join it as well.

How do you say this in English?

这没什么奇怪的
It is not surprising.
Not surprisingly.
It is no surprise to me.
I am not surprised.

Simulate a button click event on an asp.net page

Googled and found this, in other words, use "javascript:" + Page.GetPostBackEventReference(btnBack) + ";"

Google Desktop Search sucks on Outlook

I have been installing and uninstalling Google Desktop Search, its latest version, for many times these days. At first it failed to see my archived mails, well, after many reinstall, here many>=6, it finnally waked up. But, I hate buts, most time it returned nothing on my search request even though sometimes it found a little even though its index status had been set to completed for long.

I had to wipe this damn thing from my hard drive and reinstalled Windows Destkop Search though the latter use 4 times more memory, and Microsoft didn't disapoint me, it works perfect.

Shrink large database log files on our development server

Even though we have a 300GB hard disk, it is running out of space when we host more and more development databases. This morning one of my program failed because its back end database log file had reached the upper limit.

All my attempt faield as recorded as following,

1. Delete the log files directly
2. Add another log file and then try to delete the primary log file
3. Detach the database, delete those log files, then tried to attach the MDF file. It failed because MS refused to attach it when certain files are missing.

In the end I changed the recovery mode of the database to Simple instead of Full as this is a development server we don't need to restore it to the point of failure, lots of space were reclaimed.

Sometimes values missing from an Excel worksheet

This usually happens when that column is mixed with strings and numbers, Microsoft recognized it was a bug but provided no decent solution to it.

I tried to use SQL Server import, it has the issue. Tried ADO.Net, no luck either. Finnally came across a MS suggestion to add "IMEX=1" to the Excel connection string, and it worked.

Write an Internet Explorer plugin to remove Ads of Windows Live Mail Beta

I have been using Windows Live Mail Beta for quite a while and found its ads were pretty annoying. My favorite browser is Firefox which can removed ads without any hassel, however Microsoft has not proviede fully support for it so have to stick to Internet Explore for the time being.

I tried to use Maxthon, even though ads were gone but their used space were still there, so ugly. In the end I begin to write my own plugin, well, I'll say I am having a good start.

The first thing I did is to add a contect menu says Leave Me Alone implemented via adding this registry,
My Computer
   HKEY_CURRENT_USER
      Software
         Microsoft
            Internet Explorer
               MenuExt
                  Leave Me &Alone

There will be a Default string field for the Leave Me &Alone node, set its content to, in my case, files://f:\LeaveMeAlone.htm

The rest work is to create a LeaveMeAlone.htm and let it contains these below lines,

<SCRIPT LANGUAGE="JavaScript" defer>
   var parentwin = external.menuArguments;
   var doc = parentwin.document;

   var banner = doc.all.RadAd_Banner ;
   banner.style.display = "none";

   var nextFrame = doc.all.RadAd_SkyScraper; //RadAd_SkyScraper
   nextFrame.style.display = "none";

   var nextFrame = doc.all.RadAd_SMC600;
   nextFrame.style.display = "none";

   var nextFrame = doc.all.CustComm_120x30;
   nextFrame.style.display = "none";

   var nextFrame = doc.all.RadAd_SkyScraper_InMessage;
   nextFrame.style.display = "none";

   var nextFrame = doc.all.RadAd_Today300;
   nextFrame.style.display = "none";

   var nextFrame = doc.all.CustComm_300x125_TodayPage;
   nextFrame.style.display = "none";

   var nextFrame = doc.all.CustComm_300x125_SMCPage;
   nextFrame.style.display = "none";

</SCRIPT>

That's all, now when you right click in your IE window and select Leave Me Alone, all the annoying MS ads will be gone.

This has been tested on Internet Explorer 7.0 public beta only.