|Going back to square one rather:-|
Can you see the drive in BIOS?
Can you see the drive in DOS?
Can you see the drive in Windows Explorer?
If you can't see it in BIOS or DOS then it's the hardware itself.
To check the drive in DOS, boot with a Startup disk (floppy) made in Windows and note that your drive letters will temporarily increase by one letter (F for G etc).
Put in a CD and type dir x: (hit Return key) and this should show the files and folders on the CD. [X is your usual drive letter + 1]