I can quite relate to what you said. Only difference being that I don't get discouraged when I get a no light-bulb response from the person. What we offer when giving advice is one or few of the possibilities that a person can choose to solve the problem. Even if he/she doesn't think it's a way to solve the problem at least they know how you cope with it and that it is one of the ways. You never know, maybe what you say can provoke a stream of ideas which will lead to an answer.