unable to see TNS SERVICE NAME IN SYSTEM DSN

[Former Member]

Hi ,

I have issue with oracle TNS SERVICE  NAME, actually I have configured the TNS name in Tnsservecenames.ora file

but i could not see the Tns service name when I try to creat a  SYSTEM DSN  . drop down list not showing the list of TNS name

any one aware of this

thanks

mahi

[Former Member]

HI Mani,

Check the ODAC drivers version, if the drivers suitable for you operating system, check the tns entry in installed folders, TNS need to be same as the server

Please check

[Former Member]

This message was moderated.

[DayaJha]

Hi Mahi,

As "Nawal" Suggested please use tnsping command in client machine (using CMD) that you are able to access Server Machine.

and for Configuring an Oracle ODBC Data Source Name Please refer below URL.

Links:

http://documentation.microfocus.com/help/index.jsp?topic=%2FGUID.571F6E84.1EE2.4F68.80C7.B1DC863536C...

http://www.rogernoble.com/2011/01/11/need-to-create-a-dsn-for-oracle/

Hope this will help you as well.

Thanks,

Daya

[Former Member]

Hi Mahi,

Where are you trying to created this,and which drop down list (add a screenshot)?

Are you able to issue a tnsping command form the client command line?

If having problems, on the client check  your TNSNAMES.ORA, (the file name should be exactly that) and normally resides in the ORACLE HOME\NETWORK\ADMIN directory.

Regards

Nawfal