Well, I rechecked all connections and think that I might have an issue with the power connections/cables not being very consistent. I don't think the Ultra case/
psu is very good quality. However, it still seems to me that if the dvd drive is getting enough power to light up the LED that the
mobo should be able to detect it. I think there must be something wrong with the IDE controller on the
mobo or else the IDE cable. I'm going to take both the IDE and SATA drives to a local shop and have them tested. I tried everything I could think of in the way setttings in BIOS and different configs for the IDE drive but nothing worked so I'm still stuck but I I'll know more what to do next once I test the drives.