We meet once and got along well. I told him that I am working successfully with some of my projects, but the reality is that by now most of them have crashed. I am worried that when I tell him about my failed projects I will lose the credibility I have with him. Any advice would be greatly appreciated.
Everyone puts on their pants one leg at a time, so we're all roughly the same.
Just ask him if there's some task he just has a hard time getting done, that maybe you can help him accomplishing.
If not, ask him to just let you know if something comes up.
I've had many conversations like this over the years. Sometimes a conversation cooks/percolates for years, before the person converts to a client.
So...
Be relaxed. Just ask.
Oh... And ask a massive number of people.
Here's a trick...
Target looking for 100 no answers. (Geez, I think I heard this in Amway in another life.) Once you have 100 no answers, you have enough yes answers to have a very comfortable income.