As the title says, if the CD/DVD device of your VM is stuck in connecting mode, one thing to try is to shutdown the vSphere client, and restarted it.

I found this solution from http://communities.vmware.com/message/1784438, and it worked for me.