A lot of men (women as well, although with men it seems more predominant) are hard-wired to rush in with a solution. And a lot of women (and men, but it's seen more with women) are hard-wired to rush in with support.
Next time, make your expectations clear from the beginning. As in, "Dave (or whatever his name is), I have some problems and I need your support right now. Please don't offer solutions, okay? I am just looking for support, thank you."
If he ignores your more than reasonable request, maybe stop sharing this stuff with him. And if his suggestions are good ones (or at least there's one good one), revisit it when you are back home alone and can think about it, particularly if you can do so without spiking it with emotion. Because maybe he's right or at least partly right.