I must say thank youuuuuu so much. I appreciate so much for your time and guidance to fix this issue.
Actually, it took a hybrid approach. Firstly I followed the 7 step approach suggested by tangerz, which partially solved the issue I suspect but when I disabled the DHCP, as suggested by xontech, I was successfully connected.
So sequentially, I followed 7 steps and changed my IP as well, then I disabled the DHCP in my LAN setup, plugged the Orcon cable into the LAN port (not the WAN port) of the HG659 and there I was.
Thanks again guys, Love you heaps....