Just to make sure I have it right in my head. You have two ODDs, right? One just happens to be IDE, and the other S-ATA? Either way, freezing like that isn't natural, so something's amiss. Does it freeze inside of Windows, or during the boot process?
If you uninstall that S-ATA drive and things are back to normal, then I'd be willing to bet something is broken inside the drive, because something like that shouldn't happen. I've gone through a lot of ODDs in my day, and have never had something like that happen, but it's not impossible.
You may also want to make sure that your boot order is to your liking. Your main HDD should be on S-ATA 0, while the S-ATA-based ODD should be S-ATA 1. The IDE is on its own channel, so you only have one place to put it.
Wish I had better advice right now... this problem really doesn't make any sense.