You need to look in Drive Management to see if it appears there. If it does the most likely thing is that the Partition Tables have been corrupted and you need to format the drive.
If you need to recover Data off the old Drive you need some form of Data Recovery Software. If you just want to use the drive Format it and use away to your hearts content.
If you need to recover Data off the drive there are quire a few different Data Recovery Programs available and you need to chose one of these before you do anything to the HDD. When you have chosen your preferred Data Recovery Program follow the Instructions to recover the DATA of the now invisible drive . Some will require you to Format the Drive and then run a Recovery and others will rebuild th Partition Tables so it's important that you don't do anything now that could destroy your chance of recovering data latter.
There are a whole lot of different programs available
Here is a short list of the better ones
http://tinyurl.com/273ay5
http://tinyurl.com/rmvrv
http://tinyurl.com/yvrsl
http://tinyurl.com/yyk8cm
http://tinyurl.com/382vm
http://tinyurl.com/ynwnel
http://tinyurl.com/nc4kx
http://tinyurl.com/2wox7l
http://tinyurl.com/374d8b
http://tinyurl.com/djw6u
http://tinyurl.com/f73se
http://tinyurl.com/8bd3f
http://tinyurl.com/afu2j
While the last 2 are from the same company they are very different products. Win Hex should only be considered foe use by someone who knows Hex Inside Out while Davory is a great cheap General Purpose Application.
Personally I prefer the On Track Option but it's anything but cheap. However because I use this type of software a lot it's paid for itself many times over by now, for a cheaper option Spin Rite from Gibson Research or Stella have both very good reputations by other TR members.
Col