Yes but the drive can be seen and Windows can read the media in the drive it errors stating it has a file assosiation problem. This would indicate a software issue.
To the thread owner I take it this a Audio CD you are trying to use and since you got the file association error have you tried inserting another CD such as a software CD/DVD like a game and launch it manually the same as you did before from My Computer, as it sounds you might have Autoplay disabled as well.
Also with the same CD you are getting the assosiation problem with with the CD in the drive in my computer right click the drive and click explore this should launch a window displaying al the files on the CD.
Kind regards,
Martin.