System Restore is not a cure-all because it does not image the entire C partition. I have no idea what that crazy program does. However, you can try to remove it and clean up your registry.
Go into the BIOS and see if the drive is detected. Set the drive to AUTO detect mode. Reboot to windows and delete both primary and secondary IDE channels. Reboot. Still no detection? Format/reload windows should fix your problem.
In the future, always create an image file of your operating system PRIOR to any tweak. I recommend Bootit ng. It comes with a partition manager, boot manager, and drive image software in a $35 package. You can try the FULL version, FREE for 30 days.