To be honest it's best to forget the Drake Sword and instead try and find a weapon which fits your playstyle. The Drake Sword generally makes the later part of the game harder when it becomes useless and then you're forced to jarringly transition to a new weapon type which you may not be familiar with.
Get it anyways for the rare weapons achievement though.
Get it anyways for the rare weapons achievement though.