What is the model number of the drive that’s giving you problems? What are the specific problems you’re having with it?
Is your computer primarily IDE, with a SATA port or two, or is it primarily SATA, with an IDE port or two?
If you’re going to buy a new drive then you might as well make the move to SATA. I suggest getting a Sony/Optiarc AD-7240S or a Lite-On iHAS324-98. There are other recommended drives, but they’re difficult to find now.