Hi,
When you installed BizTalk on your production server, VS 2005 should have been one of the components installed, as part of the installation process, I don’t understand why it was bypassed.
The other thing is check to see if you have the correct version of ODP adapter installed on that machine.
Daniel.