If you have AmigaOS 3.9 then you should have CacheCDFS installed. Goto Devs\DosDrivers or Storage\DosDrivers and locate CD0 file.
Open the file with a a text editor, and look for the lines:
Device="scsi.device"
Unit=0
Change the lines to:
Device="uaescsi.device"
Unit=0
The Unit number should match the one for your CDROM drive in your computer, it might be 0 or a large number (if you do not know the number, enable logging in Winuae in Misc to determine it).
If it still does not detect it, then change the ASPI driver in Misc tab from AdaptecASPI to another driver eg. SPTII.