If drive wont work on other pc then:
Hardware problem prolly, most common problem on these is mobo, if you have multimeter you can check resistors that are marked with 0 and act as fuses, just put probes on each sides and if there is no connection theres probably problem with your mobo, but from far it is hard to say what may cause the problem. If fuses are blown and you need just data and willing to take a risk you can solder wire instead of the fuse or replace the fuse to risk and check if you get the board working.
but this is just most common cause i have seen them, usually fixable but still hard to say whats the problem just by this information. Thank you