specifications is 18" max.
i used a 36" ata66 cable =) for a time. replaced them with rounded 24" ones which are also out of spec ;-)
--
as for the cable blakkice, return it. IDE only supports 2 drives per channel.
if you want 5 IDE drives, get yourself an ata66 or ata100 controller. promise makes good ones.