Brian Greene's "The Elegant Universe" does a very good, completely non-technical, job of explaining the conflict between the two theories. It then goes on to explain why String Theory is one possible solution to the problem.
I'll add an additional recommendation: Stephen Hawking - The Theory Of Everything