Try to get the drive into safe mode:
- switch off your pc
- press the drive's eject button and keep it pressed
- switch on the pc
- wait 10 seconds
- release the eject button
In case the drive is detected now, it can be reflashed. In case your last flash of a PATA firmware to a SATA drive updated the firmware boot code, the drive is dead.