It sounds like that hard drive is gone. Are you getting the click-click, click-click noise? or like the sound of camera zooming in and out..lol. I dont know how to explain that sound.
IF no system can recognize the drive then it will be very hard for you to recover data. Most of the time you can recover data, but if it is a physical problem with the drive it is rare to salvage anything unless you send it to a professional service.
What you could try is buying an external drive enclosure and put this bad drive in there. Hook this up to an open USB drive and see if it will behave. Even if it doesnt show up in My Computer download the demo of this http://www.quetek.com/prod02.htm
and see if you can see the drive labeled DISK2 or something like that (you will be able to tell which drive it is or if it even see's the drive by its size) if it does see it run the LONG scan on this. Then if you see you can recover data you can buy it.