I have the same problem. But if I use the browser to go to https://downloads.maemo.nokia.com I get an Acces Denied error immediately. So apparently when I use the browser the host can be resolved. Strange, no?
I want to try the solution bjjperrott suggested here, but how do I set the DNS in the N900?