Activating Windows 8 Upgrade After a Clean Install

If you bought an upgrade edition of Windows 8 Pro you might, like most sensible people, prefer to do a clean install rather than doing the upgrade. Sounds straight forwards, right? Wrong!

Although the installation appears to work ok, when you try to activate your copy of Windows 8 it will flat-out refuse to acknowledge your legitimate Windows product key. I have no idea why Microsoft have put this block in, other than to cause headaches for legitimate customers.

Happily, there is a work around - posted by someone going by the handle BinaryInk on the Windows forum  and re-posted here for posterity:

1. Run the registry editor (regedit) 

2. Find the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\OOBE 

3. Change the value for 'MediaBootInstall' from 1 to 0 

4. Open an elevated command prompt (run as admin) 

5. Run the following command: slmgr -rearm 

6. Reboot

If you already entered your key, check the activation: for me it was already activated and I needed to do nothing more. If not, type in activate windows and type in the key; it should work. Also, do yourself a favor and export this key from regedit and save it somewhere if you ever are required to do another clean install. I know I did.

Darth Monolith

Introducing an exciting new range of action figures!

Click to embiggen

Doorhanger of excellence

I've decided to create a new range of free products that will, without fail, improve your life and the lives of those around you.

No. 1 in this fabulous new range: The Doorhanger of Excellence! Behold!

Click to embiggen

All that's left to do is print, cut out, use and enjoy!

Windows 8 - The enemy of creativity

Microsoft recently released a Preview (or beta) version of its upcoming operating system, Windows 8. I don't normally bother with beta versions of code, but I was intrigued enough by all the talk of the new Metro interface to download the preview and give it a test run. What follows is my experience of the OS in its beta form and why I believe Windows 8 is the enemy of creativity.

Ka-Boom!

Captain Morgane and the Golden Turtle (PC Review)

Introduction

I'm a big fan of point-and-click adventures and have been ever since I first played the original Monkey Island some 20+ years ago. Sadly the genre is no longer a mainstay of video gaming, with new releases few and far between, so when I heard about Captain Morgane and the Golden Turtle - a new piratically themed point-and-click adventure - I immediately rushed out to buy it.

What follows is my (admittedly amateur) review of the PC version. Read on, me hearties, to see how she fared!

Using VB6/VBScript to connect to a SQL Server 2012 LocalDB instance

In a previous post I covered how to use Python to connect to a SQL Server 2012 LocalDB instance. In this post I'll show you how to connect via VB6/VBScript. As per the Python post, you'll need to download and install the SQL Server 2012 LocalDb software, along with the SQL Server Native Client 11 database driver. 

One of the key differences - and one that took me some time to figure out - is that you need to specify a slightly different connection string: 

connectionString = "Provider=SQLNCLI11;Data Source=(localdb)\v11.0;Integrated Security=SSPI;"


One of the gotchas I encountered was with the Integrated Security parameter. If this isn't set to SSPI, you'll get Multiple-Step OLE DB Operation Errors.

Here's a complete listing you should be able to copy into a VBScript file to test:

connectionString = "Provider=SQLNCLI11;Data Source=(localdb)\v11.0;Integrated Security=SSPI;"
Set conn = CreateObject("ADODB.Connection")
Set com = CreateObject("ADODB.Command")
conn.Open connectionString
set com.ActiveConnection = conn
com.CommandText = "SELECT 'Hello, World!'"
set rs = com.Execute
while not rs.eof
    msgbox CStr(rs.Fields(0))
    rs.movenext()
wend
conn.close