Forum Discussion
Unable to connect using Oracle database and ODBC
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
4. tried to run the commands lsnrctl > start or services but i get message as mentioned below
TNS-12560: TNS: protocol adapter error
TNS-00530: Protocol adapter error
Hi Anonymous,
About the above error message, I would recommend you post it in Oracle forum to get dedicated support.
Thanks,
Lydia Zhang
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
Thank you very much. This worked for me as well. One update I would make is that for me "hostname:[port number] /SID" didn't work, but "hostname:[port number] /[SERVICE_NAME]" is what worked. I had tried pulling the SID from the listener.ora on the server but still couldn't get connected. When I used the "[SERVICE_NAME]" it connected right away. Thanks again!
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!!
