how to get the TNS service name [Archive]

Click to See Complete Forum and Search --> : how to get the TNS service name

rutu

March 17th, 2007, 04:52 AM

hi,
I am trying to create a DSN an dconnect to database. I am using Oracle 10g Express edition. Driver i am usisng is Oracle in XE . OS si windows XP. While creating DSN its asking for TSN service. Can anyone guide me how to create a TSN. I am having the SID.

Thanks for any help.

davide++

March 19th, 2007, 11:17 AM

Hi all.
Have you updated your local tnsname.ora?
This file is into network\admin directory of Oracle dir, and defines alias for Oracle SID.