For Ultra-ATA/66 drives, it DOES matter which connector is used. One connector is farthest away from the other two, that is the end to go to the motherboard. The one on the other end MUST be used for the master drive,and the one in the middle for the slave drive.
They're color coded and sometimes labelled to make sure you get it right.