Check for termination on the drive at the end of the cable. The one in the middle does not need termination but it does not hurt if it has it.

Then switch drives, making sure the drive at the end of the cable has termination. If the drive at the end of the cable still does not read (last drive of the chain) then it's the cable at fault.