Have you tried downloading a no-cd crack and using that? Even if the problem is your drive, you won't need it to run the game (considering you bought the game).
Thanks for the info. I have never been able to find the correct place to put a No CD Crack in order to get it to work. If I knew how to do this, I certainly would.