When you say your motherboard does not show your drive do you mean that it is not listed in the bios setup? If it is not then windows will not find it.
You say that you have one cable for both the sata and the power connection. at he drive end there should be 2 connectors as in the attached picture. The other end should have one connection going to the power supply and one going to a sata port on the mother board. Does that sound like the one cable you are using?