If the access point isn't providing an IP address, it suggests to me that it's not running DHCP, in which case you'll need to either configure a suitable IP address into the connection on your N900 or reconfigure the access point to run DHCP.

Personally I prefer not to run DHCP and to allocate fixed IP addresses to all of my computers, so that I always know where they are.