I suggest you keep the SATA SSd on the SIL3114 and use a quality JM20330 based IDE to SATA adapter for the optical drive . I have had good luck with SinLoon brand adapters .
I just tested such an adapter on a SATA DVD-ROM and both DOS (oakcdrom.sys) and Linux see the drive .

To give the DVD-ROM drive a workout, I booted Lubuntu Linux successfully .