Just to add to what Mike said....

you have to have 32 bit version of drivers installed on server. when you install sql server with integration services, it doesnt install 32...