Having problems connecting to Oracle 12c view

Discussion created by michael.bielinski@nrel.gov on Jan 30, 2019
Latest reply on Feb 1, 2019 by TSGal

I'm trying to connect to a view in Oracle Database 12c Enterprise Edition Release - 64bit Production from a WS 2012 R2 FMS 16.0.3 server using Oracles instantclient 18_3 drivers.  I did establish the environment variable "tsnames" successfully and the server and proper ports appear.  I installed the 64 bit drivers and got a "successful" test but when I went to establish the relationship using Manage External Data Source I could not see the Oracle view.  So, I removed the drivers and files and installed the 32 bit drive (18_3) and had the same problem.



What am I missing?  I could really use some help.