You don’t need VS2005 installed on a production server. It is generally considered a bad idea to have development software on your production servers.
You should be able to use TNSPing to check the TNS config on the production server (http://www.orafaq.com/wiki/Tnsping)
If this works then you need to check the versions of ODP.NET on the development and production servers