Friday, June 20, 2008

You can find this on a few sites, but most didn't have everything that I needed.  So for future reference, if you want to talk to a Sybase SQL Anywhere network server using ADO.NET, you need a connection string that looks something like this:

"ENG=[your server name];DBN=[your database name];LINKS=tcpip(Host=[server ip addr]; ServerPort=[port]);UID=[username];PWD=[password]"

Obviously, swap the stuff in square brackets for values that make sense in your environment.

Thursday, June 19, 2008

Crashplan Restore

Here's the scenario - you've read the previous post and installed the Crashplan stuff.  Several weeks pass, and everything has ticked along nicely.  Your backup is sat there with many gigs of data on a remote drive.  Vista "does its thing", so you decide it's time for the bi-annual reinstall of the OS.

When you install Crashplan again, alas it gives you a new 'identity' and reports that you've got a whole pile of stuff to backup.  Grrr.  It's my only complaint so far with the software - there's no easy way to tell it that this is just a reinstall and that it really doesn't have to start from scratch.

Fortunately, there is a way.  Add the following key to your registry before installing Crashplan:


In there, add the following values:

  • email, REG_EXPAND_SZ, [your email address]
  • guid, REG_EXPAND_SZ, [your Crashplan machine guid]
  • orgName, REG_EXPAND_SZ, "CrashPlan"

If you don't know your Guid, whoever you're backing up to will be able to tell you from their CrashPlan UI.

After that, install CrashPlan and it should work out who you are.  It worked for me :)

BTW, if you're on Vista64, the reg key needs to be HKLM\Software\Wow6432Node\CrashPlan\Identity.  That took a few minutes to work out :)


Checkout - it's a relatively cheap way of doing offsite backups that doesn't involve your data sitting off in some nameless datacenter 1000's of miles away.  All you do is get together with one or more friends and buy a couple of external drives; a couple of you then host the drives, and everyone else uses the Crashplan software backs up across the Internet.  What's really sweet is that for the initial backup (which could be many gigs), you can take the drive to your house and seed it locally; this was, the only traffic going over the Internet is just the deltas from the point that you seeded, so hopefully nothing too huge.  Of course, if you're doing a big photo / movie import or something, you can always grab the dive back off your mate and let it sync up locally.

The other nice touch is in the event of a disaster that means you need the backup - rather than waiting several weeks to download it, you can just grab the drive and take it home.

I've been running it for several weeks now, and it seems to be working well.  You have to buy the software, but it's a one-off purchase and it's not megabucks.

Friday, June 13, 2008

Tracepoints in VS2008

There's a really useful feature in VS2008 that allows you to insert a Tracepoint on a line of code.  It's rather like a breakpoint, but instead of halting the execution it simply outputs the Tracepoint expression to the output window.  See this for more details.

Thursday, June 05, 2008

Here's a link explaining how to do a full download of Visual Studio 2008 SP1 Beta; Useful if you're going to be installing it more than once...