Testing the connection to a new Oracle data source causes the Oracle data source window to close and an error message to appear.
Error in command:
Could not load file or assembly 'Oracle.DataAccess,
PublicKeyToken=<Token>' or one of its dependencies.
The system cannot find the file specified
Missing or incorrectly installed Oracle Data Provider.
Re-install Oracle Data Provider, see the complete guide here. Make sure that the Oracle Data Provider version is new enough and is a bit version that matches your TX DWA Software. Be sure to run the command prompt as run as administrator (a.k.a. an elevated command prompt) when performing the install, and remember to restart after the installation is complete.
Author: Doug Wynkoop