We are having some difficulties getting a new application to connect to Oracle with little help, so far, from the vendor (TIBCO). All they have recommended is installing ODAC, despite our reply that we already have the client installed. Here is our problem (and this may get lengthy as I will provide all we have done so far to resolve):
Right now we're just trying to install the new application on a limited number of developer computers. These computers all have both the 32 and 64-bit Oracle 11.2 client install (with the Administrator option selected). According to the OUI inventory, they have all the seemingly necessary components: ODBC Driver, Oracle Provider for OLE DB, Oracle Data Provider for .NET, and Oracle Providers for ASP.NET. Since the vendor has suggested ODAC, a coworker went ahead and installed it on top of the Oracle client. While it did fix the issue, it appears to have messed up Visual Studio. I'm hesitant to install ODAC simply because I've already got the 32 & 64 bit clients and I don't want to mess up the path variables and registry with unnecessary installs. Not to mention that whatever the final fix is will have to be deployed to dozens of machines, so I'd like to keep it simple.This co-worker sent me a screenshot of the files created by ODAC (12c). I found that all the OLEDB files were already in by BIN directory. However, some files were missing (like oramts.dll). After some googling, I found that the administrator install for the client doesn't exactly install everything. I reran OUI and installed the Oracles Services for Microsoft Transaction Server product, which created the missing files in by BIN directory. So now, I have the 11g version of every file contained in the ODAC screenshow my coworker provided and the application still doesn't recognize it. I have played with my path variable (the ODAC readme suggests putting both the home folder and the BIN folder at the front of the path variable) and done all sorts of combinations (32-bit first, 64-bit first). Also, my registry seems to be in order. HKLM\Software\Oracle\ODP.NET\2.112.1.0 - the DllPath setting is pointing to the 64-bit client BIN directory; Oracle\KEY_OraClient11g_home1 is pointing to 64-bit directory.
Is there anything else I can try or should I just install ODAC?