It should be possible to have 4 drives installed. One caution though, you may not have enough wattage of a power supply to handle 4 drives. Most OEM systems do not use power supplies with extra capacity.
The third hard drive is going to go on the same IDE channel as your CD / DVD drive.
Check the jumper settings on the CD drive. If it is set to Master, you either have to set it to slave, or set the new hard drive as slave.
If your optical drive is a burner, it may be best to leave it as the master drive.
You also need to mount the new hard drive close enough to the CD drive so that the cable will reach both drives.
As a side note: If you are running XP, your CD drive letter should stay the same, and the new hard drive will show up as the next higher drive letter after it is partitioned and formatted.
Chas