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 following as stated other knowledge base 1. Update the tnsname file2. Update the host information in listener and tnsname3. uninstall and reinstall the oracle instant client4. updated the environment variables Having said the above, I went to verify if my connection from the ODBC driver works fine and I'm able to connect successfully but cannot connect via Data > New Query > Database > Oracle Database and the same applies for ODBC. Please advise....A!

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

Unable to connect using Oracle database and ODBC

Forum Discussion

Related content

Database connectivity.

Unable to Connect to MySQL database

Unable to connect to On premise database

Unable to connect SQL Server Database with Power Query

Power BI unable to connect with SQL database server using an encrypted connection.