ODBCAD32 version

Posted by Harry.Zheng on 2010-08-04 0 comments

Apparently there are two odbcad32.exe:

    C:\Windows\SysWOW64\odbcad32.exe
    C:\Windows\System32\odbcad32.exe

Depends on where you start the utility, you may or may not see 32 bit drivers. The one in C:\Windows\SysWOW64 looks like the correct one if you want to edit 32 bit driver based DSNs.

Impressive WordPress upgrade

Posted by Service on 2010-06-20 0 comments

I saw a message on Admin Dashboard:

WordPress 3.0 is available! Please update now.

Clicking on the link and I got these messages coming up in a minute:

Upgrade WordPress

Downloading update from http://wordpress.org/wordpress-3.0.zip.

Unpacking the update.

Verifying the unpacked files…

Installing the latest version…

Upgrading database…

WordPress upgraded successfully

This is a really impressive upgrade procedure. I used to upgrade with Dreamhost’s one click install/upgrade button and didn’t even think about how much work is done at the background.

Sharepoint Central Administration Launches with Firefox Instead of IE

Posted by Harry.Zheng on 2010-06-20 0 comments

After installing some updates for FireFox, the Sharepoint Central Administration started to launch with Firefox instead of IE. We all have seen similar behavior in other places where the browsers compete to be the default browser, so I checked the default browser setting for IE.

It appears that IE is the default browser. I even tried to set FireFox as default browser and then reset IE as default, but that didn’t help either.

Thanks to this post, I found the fix. It appears the set as default browser action doesn’t reset the shell class in this registry location:

HKEY_CLASSES_ROOT\http\shell\open\command

After set it to use IE, Sharepoint Central Administration launches in IE properly.

Microsoft SQL Server 2008 R2 Best Practices Analyzer Available Now

Posted by Harry.Zheng on 2010-06-19 0 comments

Released on June 18 2010. 

The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool that performs the following functions:

  • Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance installed on that Server
  • Determines if the configurations are set according to the recommended best practices
  • Reports on all configurations, indicating settings that differ from recommendations
  • Indicates potential problems in the installed instance of SQL Server
  • Recommends solutions to potential problems

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591

SQL Server Installation Log file location

Posted by Harry.Zheng on 2010-06-18 0 comments

A few times I was trying to locate the installation log file folder and was having hard time finding it. So keep it here for the record.

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\