I am attempting to connect to Oracle using the tOracleInput_1 component. When setting up my connection I am using the Oracle Service Name on Oracle 11. I have done a TNSPING of the service name to obain the Host and Port and have provided the correct credentials to log in, as I am able to log in through SQL Developer. When I attemp to query a table I obtain the following error message... "Database connection is failed" Under details it states... java.sql.SQLException: Listener refused the connection with the following error: ORA-12514, TNS:Listener does not currently know of service requested in connect descriptor. We are using OID to connect with LDAP.
Thanks for your response. It turns out that I needed to fully qualify my Service name. I was putting in the Database field "SERVICENAME", when it needed me to fully qualify it to "SERVICENAME.abc.com". Once I fully qualified i was able to access. Thanks!