SQL Server 2005 Analysis Services Application Error

While accessing the SSAS tutorial on MSDN, I encountered an application problem in cube CALCULATION operation. It report information "unexpected error occurred" with "error in the application". This problem is caused by the incompatibility between SQL Server 2005 and Office 2007. An article talks about this in details. And the hotfix can be downloaded here. This bug is not fixed till now, SP1. Notice, SQL Server 2005 SP1 is needed before installing the hotfix.

今天在看MSDN上关于SSAS的教程的时候，进行cube的CALCULATION操作发生了一个SQL Server的应用程序错误。报告错误信息为：“unexpected error occurred”和“error in the application”。从网上查到这个问题是由于SQL Server 2005和Office 2007在一些DLL上的不兼容性引起的。微软提供了解决这个问题的补丁，但是，目前的服务器补丁（SP1）还没有提供这个问题的修正。这篇文章详细描述了问题。补丁可以在这里获得。注意，安装补丁之前需要先安装SQL Server 2005的SP1。

[update: 03:30PM 29Jan2007]

No, it cannot be resolved by the hotfix. Some discussion are here. I solved the problem by keep the DLLs in the same version in the 3 directories. They are,

Files msmgdsr.dll, msmdlocal.dll in directories:

1. C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\

2. C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\

3. C:\Program Files\Common Files\System\Ole DB\

Version 9.0.3009.0 doesn't work. But, 9.0.2047.0 does.

 

 

del.icio.us tags: SQLServer, Tech

del.icio.us tags: SQLServer, Tech

Manual List

CASIO EXILIM EX S600 (PDF, CHS, 4.27M)

CASIO ILLUMINATOR 2747 (PDF, CHS, 721K)

PEUGEOT 206 User Manual

MIO PDA P350 User Manual [CHS]

PANTECH PG3200 User Manual [CHS]

Freeware

Many freeware list could be found on the Internet. I draw my own list. Not to point out the TOP tools, but merely share my opinions. The tools are mostly for Windows platform. The web-based tools are considered as well. [在网上能找到许多推荐的免费软件列表。我也把我自己的列一列吧。列出的不一定是最好的免费软件，但都是我用过一段时间，觉得很好用，很上手的。大部分来自于Windows平台，也有基于web的在线工具。]

• Adobe Reader - Surely I have it on my PC. [既然是免费的，那么自然是PDF文件的首选阅读器啦。]
• PDFCreator - Very easy to use. A virtual PDF printer can be found after installation. [PDF文件生成器。安装之后虚拟出一个PDF打印机，所谓声成PDF就是在这个打印机上“打印到文件”就可以啦。]
• StarDict - Dictionary software, together with many famous dictionaries. [“星际译王”，一款很好的字典软件，还有很多很好的字典文件可以下载。现在还提供了在线的字典服务。]
• 7-Zip - compression program. A good tool to replace WinZIP and WinRar. [压缩/解压缩工具，支持WinZIP和WinRar的格式。用过WinZIP或者WinRar就一定会用它。不过，似乎不能压缩成RAR？]
• Firefox - A powerful, extensible web browser. [web浏览器。大名鼎鼎。有很多实用的插件！它和IE我都用。]
• Google Reader - A handy powerful online feed reader. [Google推出的在线Feed阅读器。刚开始可能会有点不太习惯，用用就发现他的好处了，快捷键支持的好，很方便。现在是我的主阅读器，Bloglines退居备份位置了。]
• Live Messenger - IM support both Microsoft and Yahoo Passport. [早就不用QQ了。现在国内的互通情况也大大改善！没有理由不用。]
• Google Talk (Gtalk) - Google's IM. Light weight. [G老大的产品，小巧！简洁！实用！很Google！]
• AVG Free - Anti virus tool. [在学校的时候用了一年多，挺好的。毕竟，Norton什么的都要钱，而且，只要保持更新，自己小心一些，对付病毒没什么大不了的。]
• ZoneAlarm - Firewall. [用AVG Free的时候，这个就一直是防火墙了。配置过程需要琢磨琢磨，性能什么的都蛮好。]
• StreamRipper - A stream download tool. [可以用来下载音频流保存在本地。]
• StreamBox Ripper - A good audio file converter to mp3, wma. [一个小工具，可以用来把rm转成mp3。好用，但是好像需要先安装real player或者real的解码器。原始文件的下载已经不支持了，如果实在找不到，可以从这里下载。]
• PuTTy - SSH Client. Light weight. [SSH客户端。小巧，简洁，不过中文支持不是很好。]
• FileZilla - FTP Client. [FTP客户端，我现在基本上只用这个了。注意：缺省的是两线程同时下载，需手工关掉。]
• Gimp - Graphics processing tool. Photoshop like. [很像Photoshop的图形处理工具，强大！需要Gtk支持，完整安装时会自动安装的。比Photoshop要难用，毕竟是免费的啊！]
• IrfanView - Image viewer. [非常好用的图片浏览器，从mm那里知道的，爱不释手。]
• Picasa - A surprising image album manager powered by Google. [又是G老大的东东，“酷”就一个字！]
• PSPad - Text editor. [类似的免费软件有不少，Notepad++、JEdit等等，不过，用了几个之后，考虑到十六进制显示，中文编辑等等问题之后，还是选择了PSPad。如果有一天UltraEdit能免费就好啦！]
• Emacs - Text editor. [如果只说是文本编辑器那太委屈它了，它强大的几乎“无所不能”，尤其对于快捷健Geek们来说，没有比这更好的工具了。说实话我用它并不多，但这并不影响它的地位。]
• Daemon - Virtual CD/DVD driver. [将映像文件虚拟成光驱的首选工具。]
• IsoBuster - CD/DVD/Image tool. [除了刻盘，还可以扒光盘。]
• Windows Live Writer - An Excellent blog tool. Nearly not be considered as a traditional tool from Microsoft. [间接好用，太不像微软开发的工具风格了。这篇就是用它编辑的。]
• Foxmail - Email client. Chinese supported very well. [免费的邮件客户端软件里面这个对中文支持最好啦。]
• Gmail - The first huge webmail powered by Google. [G老大的第一个要用户注册的产品。]
• IsoBuster - CD/DVD burn tool, also handy to rip CD/DVD. [刻录，扒盘都可以。]

有几个别人的link，一并贴上来：

• Open Source Windows - Free, Open-Source software for Windows
• Neowin's Freeware Alternative List - Neowin Forums
• TOP 300 Freeware software! winAddsons.com

del.icio.us tags: tool, freeware

Technorati tags: tool, freeware

Last update: 2007/04/27 09:275 PM

Links for Life

Some useful links in daily life.

Beijing Traffic Management Bureau (北京市公安局公安交通管理局）

中国气象局 [北京包头银川西安香港]

问天网-北京天气详情

金逸影城

星美国际影城

del.icio.us tags: life, government, tool, weather

,

Technorati tags: life, government, tool, weather

A funny image about project

A very funny image describe the different view point of customer, designer, programmer, consultant, and some about the documents, etc.

The image link is http://www.linuxkungfu.org/images/fun/geek/project.jpg .  Click to view in full size.

 

del.icio.us tags: fun, image

Technorati tags: fun, image

White Board

Please feel free to leave your comments. I will check this board daily. Please leave your email if you want response. However, both your comments and email can be seen by EVERYONE.

XAML and WPF

Some guys came to present the coming design suite: Microsoft Expression. The demos are really cool! From the technical point of view,  the WPF is the base of that, and XAML is used as the standard file format. The suite seems a powerful tool to develop flash-like web pages and applications. It support 3D modeling, vector graphics. The well interaction with Visual Studio makes it good tool to connect designer and developer. So far, the WPF/E objects need a plugin installed on the browser. The installation will start automatically on the browser at the first time browsing a page containing WPF/E object. Furthermore, a bigger patch is needed for a WPF application. Whatever, it has been included in the .NET 3.0 framework.

To produce very cool UI effects is the main target of WPF. Some good demos and applications can be found here:  the Yahoo Messenger for Vista, the New York Times Reader.

Related links: XAML.net, MyXaml

今天有一个关于新产品的演示，是即将上市的设计套件：Microsoft Expression。非常酷！它基于WPF技术，采用了XAML格式。利用这套工具可以开发出和flash类似的网页应用和普通应用程序。它支持三维建模，矢量图。它可以和Visual Studio进行交互，这样就可以很好地将设计人员与开发人员联系在一起。现在，浏览带WPF/E的对象需要浏览器下载一个插件，这个可以自动进行。而如果要运行WPF的应用程序的话，则需要.NET 3.0框架的支持。

WPF的主要目标是提供很酷的界面效果。网上有一些很好的演示，也有成型的产品：Yahoo Messenger for Vista（Yahoo为Vista开发的新版Messenger），New York Times Reader（纽约时报的电子阅读器）。

相关链接：XAML.net, MyXaml

 

del.icio.us tags: XAML, WPF, tech, design, development, tool, microsoft

Technorati tags: XAML, WPF, tech, design, development, tool, microsoft

Conduit

This is a wonderful web-based tool to generate customizable toolbar.  After several steps for item selection and configuration, a standard toolbar is ready for download and install. And the binary setup file is hosted on some server provided by conduit. Also, the web provides statistics of the toolbar downloading information and so on. Introductions can be found on TechCrunch. I registered and made a very simple one. It's hosted on http://kunwu.ourtoolbar.com .

这是一个用来生成工具条的工具。基于WEB，可以定制，很棒！经过几步简单的组件选取与配置，就可以生成一个标准的工具条了。Conduit还提供了下载空间，生成的工具条可以即时下载。此外还可以跟踪工具条的下载等。TechCrunch上也有介绍。我注册并配置了一个简单的工具条，可以在这里下载：http://kunwu.ourtoolbar.com .

Book List

NOTICE: The books here are all for private use only. Please refer to the original copyright policies or licence agreements before downloading or spreading them.

Development:

C#

C# School, 14 lessons to get you started with C# and .NET. by Faraz Rasheed, 338 Pages, 3.51MB. [added by WU Kun, 2007/01/08]

---

Last Update: 2007/01/08 03:30PM

Hello world!

It's the first post.