There are several versions of the Sil3112 controller. One for expansion cards (PCI to SATA controller, using the 'BASE' bios), one for raid add-in cards (PCI to SATA RAID controller, using the 'SATARAID' bios) and the last one for integrated motherboards (likely beign a striped down version of the SATARAID bios).
The 'BASE' version is known to support "CD-ROMs, CDRWs, DVD-ROMs, and DVD-RWs", but nothing is said about the other versions.
I think Windows/Linux should detect the drive and be able to use it propertly on the A7N8X-E; but it may have some problems like not letting you boot from the CD-ROM drive.