How to calm his stomach & make him more comfortable...?

The ginger ale is a good idea, but in order for him not to throw it back up, tell him to take small sips at a time, not to drink normally. This will prevent him from throwing it up and therefore give him some energy (sugar) and keep him hydrated. If his stomach hurts, tell him to lay on his right side with his knees bent a little, it actually helps.