I am trying to connect to Oracle source from lumira desktop. I installed Oracle 11 JDBC drivers from Lumira preferences. And i chose 'Query with SQL' and selected Oracl11 JDBC driver, enter the credentials , server name and port and Service name (Defined in my TNS file). I get below error Driver error: Listener refused the connection with the following error: ORA-12514: TNS listner does not currently know of service requested in connect descriptor"
Did anyone seen this error?
OS- Windows7
Lumira 1.28
I know i can connect to this DB, tnsping/PL.SQL developer