There are a number of videos on computer building on YouTube, like this one which (sorta) explains the cables and connections that go to hard drives and optical drives http://www.youtube.com/watch?v=2CULpfCaDbI
Search "computer build" there.
If you're going to get that far into your computer and you're attempting to use the (now 8 year old) mobo, I really would suggest looking into a whole new build.
If you look around on the mother board very carefully. you will find the diagram for those connection. In my experience it will not be anywhere near the pins that you will need to connect to. it is there tho. just look real good and you will find it. start over near the cpu and work your way toward the cmos battery. some where in there. I have also seen the diagram near the ram. Looks like a tiny excell spreadsheet.