Where do I plug in the cdrom connection to the motherboard?

Assuming that you have an IDE CD/DVD drive then you would Plug the unit into the IDE connector noted in the following picture. If your cd rom drive is SATA then it would connect to one of the numerous SATA connectors on the border of the mainboard.