I downloaded all that's here and tried them since just plugging in the drive did nothing:
https://www.lg.com/us/support/software-firmware-drivers?customerModelCode=BH16NS40&csSalesCode=BH16NS40.AVAR10B&category=CT30000780&subcategory=CT30011740
I thought about the adapter being defective, but...
I mentioned in the post that I tried this but didn't help. Others said after doing that the DVD/CD-rom category appeared in the device manager for them, for me nothing changed.
I got a new PC but the house have no place for my old internal blu ray drive (LG BH16NS40) and since I'm not using it regularly getting an external case would not be the most cost efficient option because they are way too pricey for 5 inch drives.
I got a sata to usb adapter with a 12v power...