Open up hardware devices in Vista and make sure the CD\DVD drive is being recognized. If it shows up OK, you might try removing it from the hardware tree and reboot Vista. Vista should pick it up on booting and install the drive plus its driver. That might get you back in business if nothing else is wrong.
Regards.