Did you try running the firmware update again? Do you have another PC to try the drive on? If it doesn’t show in Disk Management most software won’t work for retrieval or repair. Did you try deleting the driver disconnecting drive rebooting and reconnecting? Find a Linux Live CD download burn to disk and try booting from that and see if you can find drive and data.
If you can’t see the drive in disk management, then either the bridge board (the case) failed, or your os has not install the drivers properly. Have you tried updating your usb 3.0 drivers? that’s done through your pc manufacturer. have you even installed the drivers? if your media player recognizes it and can play media from it, that’s because it’s accessing the drive from usb 2.0. so, either the usb 3.0 port has failed, or it doesn’t have the drivers installed. try connecting the drive to your pc using just usb 2.0 cable and see if that works.
My P.C. is running Windows 7. I also put a new SATA hard drive in my P.C. recently because the P.C. was telling me the original SATA hard drive was failing and needed to be replaced. I decided to keep the old hard drive in its original position and add the new drive as a second one. As originally installed, the P.C. still started from the old hard drive and could not ‘see’ the new drive.
I have looked for ways of changing the software to tell it to read the new hare drive (Boot or Startup menues) but can’t see how to do this. The only way I have found to get round this is to physically swap the data cables over between the old and new drives. It seems that the mother board recognises the drive connected into one particular port and not the other. I don’t know why. I hope this helps.