I do not know of anything that would cause two different optical drives...to have a problem of intermittent function.
Have you checked Event Viewer for possible clues?
How To Use Event Viewer - http://www.bleepingcomputer.com/forums/t/40108/how-to-use-event-viewer/
You should be looking for errors which indicate that a given disk/drive (Disk0, Disk1, etc.) has a problem.
If you are using Real Player as the default program for opening CD/DVD files...I would suspect that Real Player may need uninstalling...although RP should have nothing to do with a file view from My Computer/Explorer.
FWIW: Optical drives use a generic driver supplied by Windows...for functionality. Although I've never heard of an instance of such, I suppose that driver could be damaged.