I reckon I'll have to just dump the drive, I tested the power plug and it's live at the drive end, plus my other external drive works fine.

Am I supposed to hear the disc spinning with the power plugged in? if so there is definitely something wrong because I don't hear a thing.