The 'MSDAORA.1' provider is not registered on the local machine
I figured out the solutions for this. The problem stemmed from running the machine on a 64bit machine. To change that in VS, open up the properties page of the solution and in the build tab change the targeted platform to x86. And that did the trick.
Thanks for your help Yuriy.