|I would start by cleaning the drive. Cleaning kits can be found in cheapo stores.|
Then assuming it is a desktop, reseat its interface cable (maybe both ends) by slightly pulling out, then pressing home.
If the drive did work and now it does not, bear in mind they are throwaway devices as replacing is inexpensive.
Have you changed the o/s recently, which might explain why no autostart. Although I doubt this as you advise there is also trouble with 'seeing' the cd.
Good Luck - Keep us posted.