hi locat, and welcome to sevenforums,
are you sure that the drive is faulty, not just the one disc?
try putting in a dvd movie disc, and see if that shows up.
also windows explorer is set up by default to not show empty drives - in windows explorer, hit the 'alt' key on your keyboard >> this should bring up a menu bar near the top of the window >> click tools >> folder options >> goto view tab >> untick 'hide empty drives in the computer folder' - your drive should now show up.
if it turns out that your drive is indeed faulty, don't worry as they are cheap, of a standard universal type and size, and are simple to replace.