The manual shows the following:-
Intel® Z97 Express Chipset with RAID 0, 1, 5, 10 and
Intel® Rapid Storage Technology 13 support
- 1 x SATA Express port (black at mid-board, compatible with 2 x
SATA 6.0 Gb/s ports)
- 1 x M.2 socket 3*
- 4 x SATA 6.0 Gb/s ports (gray)
- Supports Intel® Smart Response Technology, Intel® Rapid Start
Technology, Intel® Smart Connect Technology**
ASMedia® SATA 6 Gb/s controller***
- 2 x SATA 6 Gb/s ports (black)
* M.2 Socket 3 shares bandwidth with SATA Express, and supports
M Key and type 2260/2280 storage devices.
** These functions work depending on the CPU installed.
*** These SATA ports are for data hard drives only. ATAPI devices are
not supported.
If you connect your DVD to one of the two black ports, your optical drive will not work (ATAPI devices are not supported).
If you connect your DVD to one of the SATA Express ports, your optical drive will not work (M.2 Socket 3 shares bandwidth with SATA Express).
That leaves you with the four gray ports which should (in theory) work with your DVD.
Which SATA port is connected to your DVD? Try a gray port (SATA6G_1, SATA6G_2, SATA6G_3 or SATA6G_4).