If the CD isn't physically damaged, as in scratched, the best software that I know of is Easy Recovery http://www.ontrack.com/software/ , but man, it's expensive for a one shot deal. Unless you'll be able to make it earn money for you later on, or that file is really important, it's a large chunk of change.
 
It does work, I've scooped files from a formatted HDD, very good software, very costly software.

^^ Ontrack is a great company with quality software, if your looking for a possible cheaper way, You may want to check out
 
http://www.smart-projects.net/recover.php?page=http://www.smart-projects.net/isobusterdownload.htm (IsoBuster) can sometimes recover files from CD's and is free.
 
Other software,
http://www.naltech.com/
http://www.cdroller.com/
http://www.jufsoft.com/badcopy/

Hello,
 
Do you have an old CD-Rom drive 4x-8x speed?
 
If you do try reading the CD with it. This trick worked a couple of times for me.
 
Good Luck

Hi Guys,
Thanks for all the replies. I don't know what's happened to this phpBB (NT Compatible Forum), but it's pretty screwed up at this point. I used to get a notification e-mail when someone responded to my posts. I'm just now reading your responses for the first time . All of your suggestions were excellent. I will have to find a SCSI controller, if I'm going to do the 4x-8x suggestion and yes that does work wonderously well . That was something I once knew and had forgotten all about. I think I'll start by giving ISo Buster a try. I'll let you all know how it goes.
Thanks Guys,
Christian

Hello,
 
[censored] DataRecoveryWizard utility can help. Speaking about me, it was
easily able to restore deleted, lost file and unformat drive,
so I think you will also find it quite useful. Really recommended
tool, give it a try.
 
http://www.[censored].com/