...
My problem is simple: my DVD-ROM drive is IDE, and my motherboard only recognizes SATA.
If that were true, then you've answered your question - you've said that your components are incompatible. Therefore what you want to do would be impossible with just those components. You'd have to add an interface card.
Fortunately for you, I think that is incorrect.
Is this:
http://www.newegg.com/product/product.aspx?Item=N82E16813130055and
http://www.msicomputer.com/product/p_spec.asp?model=P965_Platinum&class=mbyour motherboard?
If so, on the newegg page, see where it says:
"Storage Devices
PATA 1 x ATA100 2 Dev. Max"
That is saying that board supports two IDE drives on one cable.
Also see:
On-Board IDE
"One Ultra DMA 66/100/133 IDE controller integrated in JMicron JMB361
• Supports PIO, Bus Master operation modes
• Can connect up to 2 Ultra ATA 133 drives "
on the MSI page. It says the same, with more detail.
So, if that is your mb, then it will handle IDE drives.
The floppy has the drivers I found on the manufacturer's website, but it still isn't allowing me to view my CD contents.
Instead, do what patio suggested.