Apple made a universal CD-ROM driver which is a little better than CD-Sunrise if you can get it to work. Definitely try both, but the Apple one can read more formats of CDs or something. You can download it here:

http://www.macdrivermuseum.net/disk.shtml

Install 5.3.2 first, then overwrite the extension with the 5.3.1 version.

Also, if you have a bootable CD, like a System Software CD, you can insert it, restart (not booting from it), and often times it will magically make the CD-ROM work until you shut down.