I've driven my big boy all over the country. MD to Texas, Tejas to Jax... Jax to MD for a week trip... We used to sedate him with a mild sleeping pill but lately he's been fine without it.
If they enjoy short car rides, they'll usually travel well. He rides fine in both my 4 door taco and my wifes little volvo s40, just gotta make sure he has enough room to lay down. If your dog has a bed he sleeps on, its a good thing to throw in the back seat so he has an idea what he's supposed to do back there (lay down and sleep it out).
good advice with the dog bed.
Our dog slept in a kennel at home so whenever she came on long trips, we just brought the kennel along, she knew what she was supposed to do.
Now not saying you have room in the car for a kennel, but you cannot go wrong with the dog bed.