A socket that can accept a 3.5" cable header shouldn't be able to accept a 3.5" drive... or am I missing something obvious?
The ones I've seen have been 44-pin female to 40-pin female plus power -- in other words, they plug into your motherboard, not your existing cable. (This rules out master/slave configurations, though.)

Peter