Battlefield 2142 failed to run, what else?

Hi,

This is like the 5th forum I have been to for help. I bought a brand new
computer today with windows 32bit installed and I bought a copy of
battlefield 2142 to try the computer out. The computer I bought is a brand
new computer designed for gaming, that is in no matter the question, and yes
I have experience with gaming and didn't take their word for it when it came
to hardware. What is the question is why can't battlefield run on vista? I
installed the game and it wouldn't even get to the intro video. When I ran
it as admin, same problem. Then, when I tried to switch the compatiblity it
failed even worse by asking to insert the disc, even though it is in there.
I have collected enough enough from EA to believe it is Vista's fault and I
have installed all updates for the game and vista so that can not be the
issue. Any suggestions at all, or suggestions where I can sell the game to
get most of my money back if I can't get it to work?