Check a few things here. And proceed methodically so you can keep track of all the settings. Since the immediate need is to get the HDD to function as your boot device, connect only that one device, and leave the optical drives out of the picture for now. They can be re-connected later when the HDD is working.
1. Take a close look at the ribbon cable you are using. There usually are different colors for the connectors. The BLUE on on the end MUST go to the mobo connector. Usually the other two are black (end, for Master) and maybe gray (middle, for Slave). Odd as it may sound, I have heard of people who had trouble putting the wrong end in the mobo port connector.
2. MingDragon has a good point about possible poor keys that allow plugging the connector in the wrong way. If there is any confusion, here is another set of clues. Look at the ribbon cable. On the side of the cable on ONE edge only you will find a red stripe. This is for PIN #1. Look now on the mobo for a label beside the port connector - it will have the number 1 printed close to one end. That's where the #1 pin is, so the cable plugs in here with the red stripe on the end labeled "1". Same thing on the HDD unit - its case will have diagrams of the edge connectors on the back, and an indication of which end of the 40-pin data connector has Pin #1 - red stripe here.
3. Decide which system you want to use for setting Master and Slave. If you go with Cable Select, set the jumpers on ALL of your devices to the "CS" setting and don't try others. The END connector of the cable MUST plug into the Master device in this case, and the middle connector will establish the Slave device. You really are supposed to have a Master on each IDE port, although there are a few that can work without one.
4. If, instead, you opt to set your own, for each IDE port set ONE device's jumpers to the Master position, and the second device to Slave. Use the diagrams on the devices to make these settings. Pay attention to each device's diagrams - they are NOT all the same. Don't just try out every possibility. When connecting, it is advised (although maybe not strictly required) that the END connector of the ribbon cable go to the 0one jumpered as Master.
So, try the "correct" way starting with ONLY your HDD to work with: either set it to "CS" or to "Master" or to "Master with No Slave", according to the diagram on it. Plug into it the end (black) connector of the ribbon cable, and the blue other end goes into the mobo's first IDE port, usually labeled "IDE_0". Make sure the HDD's power cable is in snugly. Power up and go immediately into BIOS Setup by holding down the "Del" key. Go to the Integrated Peripherals screen and make sure that your IDE_0 port in Enabled. Go back to the opening screen and check - does your HDD show up there with the right size? If not, you have a hardware problem to address - bad mobo port, bad HDD, or bad cable. But if it is there OK, go the the Advance screens and look for where you set the Boot Priority Sequence. Set it to use the HDD only, and not even try anything else. Save and Exit and it should boot from the HDD into Windows.
Now, if your HDD did not even show up in the Setup screens, what to check? Well, you could try changing the drive to a Slave setting - change its jumpers AND change to using the middle cable connector - then reboot and try again. What you reported above says even in the absence of a Master your mobo is able to work, so this is worth a try. If it does work this way, then you most probably have a good drive but could have a bad mobo port or cable.
If you got to this point, stop and check one other thing. Look closely at the connectors on the mobo and the HDD back edge. All of the pins should be there and straight, EXCEPT for one - pin #20 near the middle will be missing. It matches up with one "hole" on the cable connector that is blanked off. If any pins (other than #20) are bent or missing, you may have found the source of your trouble.
Anyway, if the "correct" way you tried first did not work and the pins are all OK, you can try different combinations of which mobo port you plug into, and which cable or connector you use, to narrow it down to which component has the problem - mobo port, cable, or HDD. Once we know that, we can help figure how to proceed to get it all working. Let us know your results. Once we get the HDD to work OK, we can get the opticals back into the picture.