I like Kristen's idea about being a SAHD. It may be difficult for him to accept, at first, but considering what the circumstances are, maybe that is a solution for now. Your skills may be in more demand than his for the time being.
I don't know how religious you are, but prayer is such a life-saver. I know how he feels about getting so excited about something, only to be shot down. :( It is such a blow to your confidence! So, just let him know that you believe in him and know that he will find his "niche". Pray together for him to find it (soon.) lol :)
Remember that it is difficult for most men to not "provide" for their women and families like they want or think you deserve. So, just continue to keep positive, too. I know it's difficult, but that's where prayer really helps...because you've got a lot to be grateful for.
Can he teach a Community College class on anything he knows? That may help boost his confidence and bring in some money. (Not a lot of money, but more than none.) :S What about advertising on Craigslist for odd jobs? Moving help? Tutoring?
I hope you will both find comfort soon. I will pray for you, D.. Take care, Sweetie!