could Cancer (boy) and Aquarious (girl) have a good long lasting relationship?

I am afraid not. These two signs actually have too many differences so that they don't match each other very well. Aquarius need to calm down and think carefully whether you two have common ideal. If so, it's worth a try because Cancer could give you much love.