If your connector is a standard IDE, i.e. non-SATA connector, you must eitherr but a bridge connector for IDE to SATA (I am unsure whether such a bridge is possible because IDE is an ATA standard and SATA is Serial ATA), or an interface card to plug into the mobo via a PCI slot.
I left my old IDE CD drives behind because you can get a DVD burner for under $20. I suggest that you look to buy a SATA CD/DVD as an alternative. It is cheaper and less clunky than getting an interface card.