DS wouldn't even go check the school out beforehand so when we brought him there for freshman orientation, that was the first time any of us had seen it. And you're right, he absolutely doesn't want to be there, but it was the school he chose. Money wasn't the issue and we told him that repeatedly but his feeling was that he didn't get into his first choices of schools so what difference did it make where he actually ended up going. In hindsight, it made a huge difference.
I cannot tell you all what a source of comfort each and every one of you has been to us with your support and sharing your experiences. I love hearing all your stories and it truly has helped.
Just to answer some of the questions: I do think he is exagerrating the drinking part a bit but I think it stems from his feeling so disconnected as well.
The school he's going to is Duquesne University in Pittsburgh --8 hours away from us here in CT.He got accepted into Pitt and Syracuse as well. DH and I both favored Syracuse and many of his friends were also going there, but he didn't want to go there.
OK---a little update. Before going to bed last night, I texted him just to say good night, I love you, etc. He texted back with "I need help".That was it--I immediately called him and could hear the misery in his voice. His dad and I both talked to him an tried to explain that he had to give it time, wait until classes start, etc. but then he cut us off saying he was going to bed. He did mention that he was in his room (by himself) for a good part of the day because he couldn't find his group to do a tour of the city and didn't know what else to do. Last night they had a dance and he didn't go to that either. (which is fine because he's not dance type of kid). So anyway, there was no way I could sleep after that so I texted him and we ended up having a very positive conversation that way. (silly I know, but I'll take it anyway I can get it) I told him how proud I was of him for having such high standards but that he shouldn't judge people, he needed to lighten up a bit and force himself to engage. He was much more receptive and ended the conversation telling me he loved me. I felt much better after that and I think he did, too.
As someone mentioned, I do think the orientation is just a little too long--at least for him. They've had almost an entire week of it. But tomorrow he starts classes so I'm praying that will help a lot. Please pray for him as well if you can find it in your hearts.
Again, thanks so much for your support. It is truly helping me get through this.
Aha! I guessed Duquesne when you said 8 hours from CT!

I'm sorry your son and you are feeling like this -

Some very good friends of our family actually have two sons at Duquesne right now - one is a senior the other a freshman. I'm sure when classes start and he starts expanding his social circle (running into guys like these two - all-around good guys) his impressions of the school will change.
What's he studying? Just curious.