Monday, April 10, 2017

Windows Update Error Code 80070002


Encountered the following error when trying to install Windows update on one of my Windows Server 2008 R2 server.

Code 8007002   Windows Update encountered an unknown error.


Saturday, January 16, 2016

Do not have permissions to use the MS Access MDB object

A user gotten a new laptop and tried to open an Access 2003 database copied from his old laptop.  Much to his dismay, the Access 2003 database failed to open with the following error message.

You do not have the necessary permissions to use the ‘C:\Demo\Test.mdb’ object.  Have your system administrator or the person who created this object establish the appropriate permissions for you.


Tuesday, May 05, 2015

ERROR [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

We had migrated an ASP.Net web application hosted in a Windows 2003 server to a new Windows 2008 R2 server.  Everything went smoothly until someone test a data upload function.  The data upload function takes a CSV data file and upload the data in it to a SQL Server.  When trying to execute the upload function, the following error pop-up.


Sunday, January 11, 2015

Porting OCS contacts over to Jabber

We are moving from Microsoft Office Communicator 2007 R2 to Cisco Jabber.  The bad news is that we were told that contacts in our OCS will not be migrated to Jabber.  We were asked to re-create our contacts in Jabber.  With 100 over contacts to recreate, I started to look for solution which I can do it at the client’s side but without any luck.

But I do notice that Jabber has the function to import contacts from a XML format specified by Jabber.  Below is the XML format.  More information about the XML structure is explained in

<?xml version="1.0" encoding="utf-8"?>
<gname>Group Name</gname>
<uname>IM Address</uname>
<fname>Display Name</fname>

Sunday, January 04, 2015

Rescuing a 2TB Harddisk

My first mission on the first day of 2015 was to rescue my wife’s 2TB portable harddisk.  She was not able to access her 2TB portable harddisk using her laptop. 

To rule out that it is cable or USB port issues, we have tried using different cables and tried on a few laptops but still no luck.

Windows is able to detect the harddisk but it will freeze the whole Windows.  Meaning that, nothing will response when I tried to run them and I couldn’t even shutdown the laptop even I unplugged the harddisk.  I will need to do a hard reboot.

I tried to open the command prompt before plugging in the harddisk.  I then tried to run a chkdsk but it just freezed there forever.

I am optimistic that the data in the harddisk can be recovered and the problem might be caused by bad file system which is stopping Windows from accessing the harddisk.

Saturday, January 03, 2015

VM in new host slower than VM in older host

Few months back, I led a project to upgrade an in-house application to a newer version running on new hardware.  New ESXi hosts with better configuration were added to the existing cluster and new Virtual Machines were created for the new version of the application.

One of the objectives of the upgrade is to increase the performance of the application based on the fact that the new VMs will be on new and more powerful hardware. 

So the team conducted performance testing but was getting some weird results.

Saturday, March 29, 2014

HOWTO: Swap Rows and Columns in Microsoft Excel

Need to swap your Excel rows to columns or vice verse, watch this video produced by my guest author.