Was it working previously, and then STOPPED working?
Did you -change anything- on the MBP -- upgrade the OS, etc.?
Could the lens on the CD/DVD drive be dirty?
Does it use a separate USB connecting cable?
If so, have you tried changing it?
I know this is "basic", but have you checked the finder/preferences panel, to see that "show CDs/DVDs" is checked?
If nothing helps, it might be easier just to buy a replacement...