If you're up to the task, you can pop open the case and check the connections to the CD drive (wide IDE cable, power cable and maybe a thin CD audio cable). You could also try the drive in another PC.
If you have no luck in bringing back to life, then it's time for a new one. Perhaps a DVD burner, considering how cheap they are nowadays?