Okay, back to basics:
1. How many devices are on this cable?
2. What are they?
3. Where are they plugged in?
4. How are they all jumpered?
Lights indicate that power is working, which is good. They don't indicate anything about connection.
Ermmmm... you did plug the IDE cable in correctly, didn't you? Red stripe towards power? I think they make it impossible to put 'em in backwards these days, but ya never know...
Next option I've got is to take something from the other IDE cable and swap it over to this one. It may have to be rejumpered to be a master, but see what's going on. And then try the ZIP drive on the other cable.
Next step is to sacrifice a Macintosh, so you may need to get ready for that one...