If your BIOS can't see the IDE hard drive then it's not Connected or it's not powered up.
Just because you have a SATA drive does not mean that your IDE drive must be "slave" The slave/master thing only applies to two devices on one IDE cable.
So you have two IDE cables one attached to the DVD and one attached to IDE hard drive. In this case it doesn't matter what the jumpers are set to. It should work in all cases.
So what's wrong?
a list of things that COULD be wrong:
bad IDE cable to IDE hard drive
bad power cable to IDE hard drive
bad IDE hard drive
bad secondary IDE drive socket and/or motherboard circuit
BIOS setting disabling the secondary IDE controller
things you could do:
Test the hard drive in the primary IDE controller
use a different power connector to the hard drive
use a different hard drive (if you have one)
check BIOS settings