Check the version og Oracle you are using in both systems - that is whether it is 32-bit oracle client and a 32-bit SQL server or both systems are 64-bit.

I believe the MSDAORA provider is for 32-bit systems. Good luck!:hehe: