As the running theme with the comments is be supportive and be patient with your child. That is pretty much the biggest thing you can do for the kid. I had no support of any kind from my family, I was always told I was useless and would never amount to anything, and as a kid who takes things seriously that is pretty damaging. I have eventually learned that I am by far more capable than I was led to believe.
Also I suggest encourage him in what ever career choices he might have an interest in, never tell him that he won't or he wouldn't enjoy it, let him discover that. As a kid I had many career ideas, but my family always told me that I would never be able to do that, so as a result I am working at Walmart at a complete lost as to what I should do with my life.
Just be supportive of the kid, don't treat him as fragile or to special. Just be patient with him and treat him as any other kid.