You can translate the question and the replies:

Error while connecting to Oracle 11g Source

I am trying to connect to Oracle 11g 64 bit remote instance from my location machine. I could able to connect the same instance using Sql Developer tool and sqlplus command line without any issues. But when I tried using denodo I am getting the below error. **Unable to establish connection:IO Error: The network adapter could not establish the connection. ** I don't think this is due to firewall issue as I could connect the same with other tools. Can you please help what needs to be done to resolve the issue. Does Denodo required oralce sql client needs to be installed. Kind & Regards Suresh
oracle database connection
user
19-10-2016 10:43:39 -0400
code

1 Answer

Hi, I got this error message from Oracle many times. It always shows up when I write a wrong Database URI** jdbc:oracle:thin:@<host>:<port>:<service name>** If you are able to connect to Oracle using other JDBC tool, I would recommend you to try the same URL used in the other tools in your Datasource Configuration. Hope this helps!
Denodo Team
20-10-2016 10:03:01 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here