Question
Northwestern Mutual
US
Last activity: 3 Jan 2018 13:49 EST
OracleQuery connection failed
When setting up OracleQuery Connection string property and test connections I get Microsoft Data Link Error for not able to find oracle client and networking components. This is a 64 bit machine and I have both 32bit/64bit oracle client installed on the machine. Is there any other setting/ installation I need to do to solve this issue?
Pegasystems Inc.
IN
Let us know below details
1)oracle database version
2)oracle connection properties
3)jdbc driver vesrion
Thanks,
Arun
Northwestern Mutual
US
1.Oracle database:
2. oracle connection string is
Provider=msdaora.1;Password=XXXX;User ID=XXXX;Data Source=XXXXXX;Persist Security Info=True
3.Oracle JDBC Drivers release Proprietary information hidden.0
Pegasystems Inc.
US
A search for this error on google brought up this result - https://stackoverflow.com/questions/9002560/oracle-client-and-networking-components-were-not-found
Since Studio is a 32-bit application, it will require the 32-bit version of the oracle client to work. There are no other settings with the Pega Robotics Studio product that will resolve this. This is more of an issue with Visual Studio recognizing the application exists / system environment variables. You may need to investigate through Oracle's help to get more assistance if you can't figure it out. There are a few other articles out there on google with people that experience the same issue, definitely check those out as well.