Option for oracle connection not showing in sql-response probe

Document ID : KB000100799
Last Modified Date : 09/07/2018
Show Technical Document Details
Issue:
We had sql_response profile that connected to Oracle Provider for OLE DB on one of the server.
We created another new server and installed Oracle 12.1.0.2.0 driver , however unable to create a connection like other server. 
There are no “Oracle Provider for OLE DB” in the provider option.
How can we correct this issue?
 
Environment:
UIM 8.51
robot 7.93
sql_response 1.66
oracle database and drivers 12.1.0.2.0
Resolution:
MS no long  third party database drivers such as MYSQL, oracle etc.
Please download the oracle 64-bit ODAC from the oracle web site for the version you need.
for there 12.2 you can go here

http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

run the installer to install the oracle client
make sure  you can create and ODBC connection to the database properly and the test works.
Once this is done you can either use the ODBC connection or now the OLEDB connection should work.
Make sure the bin directory of the oracle client path is in the system path environment variable.