Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Unable to connect using Oracle database and ODBC

Hi team,   i have access to an oracle database but for some reason I cannot access the database and keep getting error message stating "Oralce: ORA-12541: TNS: No Listener". I have tried the follow...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    Anonymous Apologies for getting back so late but I found a solution for this to work.

     

    New Query > connect to DB > Oracle Database > in the servername the syntax to use is "hostname:[port number] /SID" which I was using only as host ID. After this update, it all worked fine.

     

    Thanks again for the help.

     

    Kind regards,

    Anand

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous Apologies for getting back so late but I found a solution for this to work.

 

New Query > connect to DB > Oracle Database > in the servername the syntax to use is "hostname:[port number] /SID" which I was using only as host ID. After this update, it all worked fine.

 

Thanks again for the help.

 

Kind regards,

Anand

mattlazarus's avatar
mattlazarus
Advocate I
9 years ago

I was having the same issue and could not work out what was wrong...this change allowed me to connect fine;

 

hostname:[port number] /SID

 

THANK YOU!!