The device may be for Windows and not compatible with macOS.
The PATA bridge may use the standard driver, which is why it works There may be a specific Windows driver for the SATA bridge. Assuming you’re using the same USB to PATA/SATA adapter on both the Mac and the Windows there are a couple factors which could contribute to the symptoms you’re seeing:
