Sounds like your flat cable on your secondary IDE channel has come loose or fried, or that possibly your ATAPI/IDE secondary channel on the MB has fried.
First make sure the BIOS settings are set to run both IDE adaptor channels on the MB. The setting could have become corrupt. Reboot and see if they recognise.
Then, try just using a different cable. If the drives work right now, discard (or scavenge for hookup wire like I do with damaged ribbon cables) the dead cable.
If they still don't recognise, disconnect each drive (one at a time) and see if the other drive recognises. If this allows one drive to recognise but not the other, you have a dead drive, dump the bad CDROM or DVD.
If neither drive recognises on the second channel and you have only one HD, set both drives to Slave (check your HD, and set it to Master with slave or Cable Select as appropriate, if it is Cable Select set the CDROMs to that also) and try them one at a time as Slave devices. If both work, you can get a PCI IDE card to run them on. Promise Technologies sells a series of PCI IDE cards ranging from basic channel for running CDROMs to enhanced IDE cards that add 4 or 8 EIDE UDMA133 drives and/or SATA drives to existing systems. If the secondary MB IDE channel is toast, disable it in BIOS to free up the IRQ.
If the CDROMs don't recognise in one setting (Slave or Cable Select), try the other.