When I put in my Sims 2 game this is what pops up, NO CD/DVD - ROM DRIVE FOUND.
and check to see if sims checks D: drive by default and if the cd is marked D:
check to see if the drive is plugged in (internally)
If its powered up and plugged in, then it may be a hardware problem
Check device manager on the computer to see if there is any hardware that needs drivers, or is damaged - if not, you need a new drive. They're cheap (20 bucks) for a plain jane dvd burner.