I have had the missing drive problem frequently and find it to be a poor connection. To solve it I usually disconnect the power cable and the ribbon cable then reconnect them both and this usually solves the poor connection. The alternative is to replace the ribon cable.
Do you have a card reader connected to your computer? this would explain the mutiple drive letters.
Other that this info I can't help without looking at the computer in person.