Skip to Content
avatar image
Former Member

unable to see TNS SERVICE NAME IN SYSTEM DSN

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jun 13, 2013 at 01:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 17, 2013 at 07:09 AM

    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.B1DC863536CB%2FGUID-1D791A6B-4B9F-457D-B617-A441E0362082.html

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

    Hope this will help you as well.

    Thanks,

    Daya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 19, 2013 at 06:00 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 19, 2013 at 06:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded