This discussion is archived
6 Replies Latest reply: Oct 26, 2012 1:57 PM by Mark Williams-Oracle RSS

sqlplus connects from client - Add Connection from with VS2010 fails

970958 Newbie
Currently Being Moderated
Hi,

Just installed today Oracle 11g Express Edition on server Oracle11g.
And on a W7 VM installed VS2010 with ODP.Net

My tnsnames.ora:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Oracle11g.domain.local)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

With sqlplus i can connect to the server, but "Add Connection" in VS2010 fails with "ORA-12154: TNS: could not resolve the connect identifier specified".

Can someone give me a hint?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points