These SATA connector adapters are as diff from each other as chalk and cheese.

Many different varieties, like Heinz soup.
So, there is really no generic answer. Did it come with the mobo? Then check the mobo manufacturers website for an answer.
Oh, the HDD WILL need a separate molex connector. IDE doesn't power like that. The question is whether the ADAPTER needs power.
Not much help, eh?
Cheers
Mick