VirtualBox: Clone Windows and Stay Genuine

One of the great benefits of virtualization software, such as VirtualBox, the ability to clone an installation, use it, then remove it. Personally, I keep a backup of the original installation, up to date and loaded with common software. When I need a new machine for testing, I clone the original, reinitialize the MAC addresses, and get to work.

Unfortunately, a cloned machine will act as if it was never authenticated, since the clone process asssigns a new machine UUID. Thankfully, there is a simple workaround,

Continue reading

Rescuing a Sony Vaio

In the early part of this decade, the Sony VAIO was a very impressive laptop, large displays, powerful processors an so on. unfortunately, they also had some flaws, not the least of which was some faulty soldering on the memory slots. This particular issue effected several models, and there are numerous sites and forums dedicated to fixing this issue. The best approach would be resoldering, however, if like me, you have neither the skill or equipment there is a low tech solution.

Continue reading

Windows: Annoying DUN Pop-up

Thankfully, DUN (Dial-Up Networking) is a thing of the past for many of us, at least as far as internet connectivity goes. However, it can still be used to connect to simple VPNs.

Using DUN to facilitate simple VPN connections is great, until an application tries to access the internet with an address that does not exist or is non-responsive. Then you get this annoying little pop-up window asking you to connect to your VPN,

Continue reading

.NET, OleDB and Excel

OleDB is a very useful API in .NET, especially when programmatically manipulating the data in an Excel spreadsheet. In fact, it can open an Excel spreadsheet and query the data using regular SQL statements.

using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=somedataineed.xls;Extended Properties=\"Excel 12.0 Xml;HDR=NO\";");

The connection string is fairly standard. However, notice the ‘HDR=No’ under extended properties, this tells the connection to assume that the first row does not contain header text. By default, or if ‘HDR=Yes’, the first row will be disregarded as headers and the first row of data may be skipped, be CAREFUL.
Continue reading

WifFi 1.2b

WifFi 1.2b (second edition) is ready!

Get it here.

This release includes an optional WifFi-VEN-DB.pdb (621KB). If you choose to install it, WifFi will attempt to “guess” the hardware behind each detected AP. To access this information click the SSID header twice, it will flip from SSID to MAC to VENDOR.

NOTE: This will only work for AP’s found (or refound) after the Vendor DB is installed.

Enjoy!