What OS are you using XP, Vista?
In any case all drivers for dvd drives are in OS, it should recognise your drive on start up.
Check Device Manager, if you can see your drive there.
If yes than it should work, if it does not work, than uninstall drive from there.
Shut down computer, wait for 10 seconds and restart. OS will find a drive and load appropriate driver.
If it cannot find the drive, than most likely something went wrong with it.
First make sure that all cables to a drive are connected and seated properly, as it could happen that during HD install some got loose.