Confidence is required but over confidence should not be there. At the same time we should not underestimate other's abilities also. We all know the tale of hare and tortoise. Hare is having over confidence and underestimated the competitor. Hence hare lost the game.
For success we should have confidence but not overconfidence.