Database connector: Error while connecting oracle database

0
Hi, I'm trying to connect to an extenal database i.e. Oracle 11g using Database connetor. I have given the following jdbc url in execute query  'jdbc:oracle:thin://192.168.1.10:1521:XE' I'm getting the following error : ORA-12505, TNS:listener does not currently know of SID given in connect descriptor    
asked
1 answers
3

this syntax will work:

'jdbc:oracle:thin:@[IP]:[Port]:[SID/Service Name]'

answered