Dvd Rw No Worky - No Power

Morning all

I have a HP Pavillion 9700 laptop. I noticed the drive icon disappeared on the my computer screen
Then i noticed there is no power to the dvd rw drive as also no lights and i wasnt able to open the drive tray.
I have tried removing dvdrw drive and cleaning contacts etc with air duster, it isnt even there in the device manager page either
So i purchased a new slimline notebook drive similar to previous one, still nothing.
So when i put old one back in it reappeared then next time i booted up, it was gone and not to be seen again

any ideas gurus