Afraid I have to agree with John on this one (and how I hate doing that

).
Sounds like you've got the wrong router there matey. The reason that turning DHCP on in the router is borking your connection is probably that the router is trying to specify an IP address for the Cable Modem, it's plugged into the network port so it's being treated as a networked machine rather than a gateway.
Sorry