Do you have a bootable cd? Like a Windows install disk, a memtest disk, linux disk, anything thats bootable will work. Put that in, make sure your bios is set to check the cd drive first and see if you can boot off of it.
If not, check all the cable connections (power at drive, ide at drive, ide at motherboard). IF it still doesn't work, your drive is dead.
If it does work, but still doesn't work in Windows, delete it from device manager and reboot.