Our son did, indeed, bring me back a SATA DVD drive and it's working.
Thank you very much to all of you who took the time to write and offer suggestions.
My current motherboard has an IDE connector, but the motherboard I'm upgrading to does not. I have two new IDE-to-SATA cables and I get the same negative results with both: The BIOS states that the SATA slot for the CD/DVD drive is empty. When I connect a hard drive to the same slot, the BIOS has no problem identifying it. Just to be absolutely sure, I tried both the CD/DVD drive and a hard drive (one after the other) in another slot, and again, the BIOS recognized the hard drive but not the CD/DVD drive.
One tech support person suggested that if the CD/DVD drive isn't jumpered as Master, that could cause the problem. I was almost certain that it was jumpered as Master, but double-checked just to be sure. It was.
Since it takes about an hour to remove my current motherboard, install the new one, try out a suggestion, and, if it doesn't work, swap out the new one for the old one again, I'd like to get as many suggestions as I can before trying them so that I can try all of them in an hour, instead of an hour for each one.
Thank you for any help you can offer.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic