Try this fix:
Download XP_CD-DVD-Fix.zip and save this file to your hard drive. Navigate to where you saved it and double click the file to extract the contents. Locate the EXE file you extracted and double click it. A confirmation dialog will appear when the script is done. You may need to reboot for the change to take effect.
This utility is only intended for Windows® XP.
www.dougknox.com/xp/utils/xp_cd-dvd-fix.zip
If that doesn't work, you go about the-usual-suspect-list:
1. Make sure you have the latest firmware before you do ANYTHING.
2. Remove all software involved with this drive - remove it from Device Manager - remove the controller it was on also (probably the Secondary) - shut down - disconnect the drives' power - reboot.
3. Shut down - reconnect - reboot. XP finds the drive and reinstalls it.
If still no luck, post this problem under Hardware - Storage - Optical in this forum.