Author Archives: daniel

Ultimate geek nostalgia: help fund a doco about the origins of the UK games industry

Yesterday marked 30 years of the Commodore 64.

Meanwhile, a documentary about the origins of the UK games industry in the 70s and 80s, From Bedrooms To Billions is in the works, but needs pledges of support to be made.

If you donate, depending on the amount, you get some pretty cool gear including a digital or DVD copy, posters, your name in the credits, a T-shirt, and even a personalised portrait of yourself from ZZap64 illustrator Oliver Frey. Some of the higher donation amounts actually include vintage computers/consoles and signed (by the authors) copies of classic games for them. Zowee.

They’re aiming to raise the money by 17th of August.

From Bedrooms to Billions

My PCs

I have two desktop PCs at home; a no-name and an HP.

One of the big benefits of the HP is that the specs are all online, which has made checking hardware and preparing for upgrades easier. This and the slightly better build/design is probably enough to have me looking at name-brand PCs next time.

The specs for the no-name one were online (as part of the product sales information), but have recently disappeared, so — more for my own purposes than anything else — I’m copy/pasting them both here, with corrections for previous upgrades.

Yes, I realise they’re both long in the tooth. I’m on a budget here. No doubt this will all look pretty funny in 5-10 years when looking back.

Tintin

We use this as the workhouse computer, office stuff, that kind of thing.

Bought off Zazz in 2007.

Case: X-Sonic 7022 ATX

Processor: Athlon 64 3500 (2.2Ghz) 64 X2 Dual Core 4400+, 2.3 Ghz

Motherboard: Gigabyte GA-M61SME-S2 with onboard graphics (GeForce 6100), PCI-E, 6xUSB2.0 (two at front, four at rear), LAN, Audio etc.

Hard Drive: Samsung HD250HJ 250GB SATA with 8Mb Buffer

Optical Drive: Samsung WriteMaster 18x Dual Layer DVD+-RW Burner

RAM: Transcend 1GB DDR2 533Mhz 3Gb

(Previous posts on this PC: When I bought it; shopping for a CPU upgrade; installing the CPU)

Haddock

This one is a tad faster, and is used for video capture and editing, as well as everyday stuff.

HP Pavilion a6760a

Case: Mid-size ATX (one of those standard circa 2009 HP jobs)

Processor: Intel Core 2 Duo E7400 (2.8 Ghz) — I really like that the HP web site includes upgrade information for this.

Motherboard: MCP73M01H1 (Napa)

RAM: DDR2 2Gb (2x 1Gb) PC2-6400 4Gb (2x 2Gb) PC2-6400 — I notice that Windows 7 32-bit can only currently see about 3.3 Gb of this, so I’m thinking a switch to 64-bit Windows may be in order, if I can determine that all of the hardware supports it.

Video: NVIDIA GeForce 9300 GS

Audio: Integrated Realtek ALC888S Audio

TV-tuner: AVerMedia DVB-T/PAL — of all the TV tuner cards I’ve had over the years, this has been the smoothest running.

Hard drive: 500 Gb, SATA, 7200 RPM. I’ve just plugged an additional Western Digital Blue Caviar 1Tb drive (also SATA, 7200 RPM) in to add to the capacity.

Optical drive: DVD+/-R/RW 16X 12X +/-DL LS 12X RAM SuperMulti SATA drive

Power: 300W power supply

(Previous post from when I bought it.)

PS. A bloke at work upgraded his PC to 32 Gb of RAM. Makes me feel quite inadequate. Damn DINKs.

Revisiting Wolfenstein

Wolfenstein 3D is 20 years old. To celebrate it’s been re-released as a browser game.

And as Crikey notes, a 1992 Sydney Morning Herald reviewer was “flabbergasted” with the game: The game, we are warned, is rated PC-13 – Profound Carnage. Good advice. There’s plenty of blood and guts, and the sound effects are blood-curdling, so my sub-13-year-olds won’t be playing.

I remember playing it at my mate Brian’s place back when it was first released — the ancient computer I had at home couldn’t cope with it.

I had a go of it again last night. Sure enough, it worked well in the web browser. After about half-an-hour of shooting Nazis (and Nazi dogs) I felt a bit queasy. I think it was due to focussing on the low-res 3D, rather than the blood and guts.

Chinese character weirdness in Windows 7

It used to be I could view Chinese characters in Notepad, Notepad++, Wordpad, that kind of thing. It stopped working at some stage: all I got was little squares. Wierdness.

No amount of fiddling with encoding settings (particularly in Notepad++, which is replete with them) seemed to fix it.

Looking around the Control Panel's language settings didn't help either. You can install extra Language Packs, but the Chinese one is for Windows Enterprise and Ultimate only. I knew this couldn't be the answer because previously it had been working, but I was only on Windows Professional.

Following a tipoff I found via Google, from someone having similar problems, I tried this: create a new local logon; log on as it; log off again; go and try again.

Sure enough, that worked. Why? Well that's anybody's guess.

Errors using AttachDBfilename and SQLEXPRESS when migrating dev code to production servers

One of the developers at work had used the Visual Studio web authentication tool thingy, which created an SQL Server Express database which was configured in his web.config to attach the file for use.

When migrating this to a server that has SQL Server (not SQL Server Express) this obviously doesn’t work; you get connection errors.

As this useful post says:

AttachDBFilename is unique to SQL Express, it spins up a user instance of SQL Express attached to a specific DB Filename for single user mode. Database is simply the name of the database to use, it has no additional connotation. For any production server, you would most likely not be using AttachDBFilename. It is strictly useful for development and experimentation in single-user mode.

The answer is to attach the MDF (database file) to SQL Server. You may want to change the database name; it seems to just plonk in the original filename (with path) there, which is pretty unwieldly.

Create an SQL Server login, and a database user (linked to the login) for it (I gave it the dbowner role, though it’s probably possible to restrict it a bit more), and then change the web.config:

  • “data source=.\SQLEXPRESS;” becomes “Server=(local);”
  • “AttachDBFilename=|DataDirectory|\aspnetdb.mdf” becomes “Database=[databasename]; User=[username]; Password=[password]”
  • “User Instance=true” needs to be removed

Cross your fingers and hopefully that’ll work.

Blogger introduces country domains, breaks some addons

Blogger has split itself into separate country domains, such as blogspot.com for US, blogspot.co.uk for UK, blogspot.com.au for AU.

But what’s really puzzling is that these apply to the user, not the blog. The blog may be visible on a multitude of different blogspot country domains, dependent on where the user is located.

This has broken a number of addon tools, such as commenting and social networking.

More details at Girl Does Geek

Google’s information on this

How to override it (though it only lists a few of the country domains; you’d need to find as many as possible to add in to make it work for everybody)

— It rather appears that Google/Blogger didn’t think too carefully about this.