I hope this is the right place to post this question, if not please re-direct me.

I have installed PowerQuery in Excel 2010 and am trying to connect to an Oracle data base. I keep getting this error;

DataSource.Error: Oracle: ORA-12541: TNS:no listener

Details:
Message=ORA-12541: TNS:no listener

ErrorCode=-2146232008

I must confess, I know very little about this, and am not an Oracle DBA. I have worked out though that I need to create a file for my TNS settings, so I created this;

MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <IP Address> )(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = MYDB)
)
)

in a file called tnsnames.ora (and set TNS_ADMIN as an env. variable to point to where it is).

I think this is right. I have tried tow Port No.'s, the one given above which all the examples I have found use, and also the Port No. that I use to connect to the DB through MySQL Workbench (which works fine).

Clearly I am missing something here, because it is not finding my TNS.

Can someone give me a steer please on setting up TNS for PowerQuery

Thanks in anticipation