on 06-13-2013 12:02 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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://www.rogernoble.com/2011/01/11/need-to-create-a-dsn-for-oracle/
Hope this will help you as well.
Thanks,
Daya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.