.NET connecting to oracle problems with the connectionstring
- by Oxymoron
At the moment I'm trying to make a connection to a local server.
Connecting via, say, TOAD works fine. When I try to connect using .NET I get ora-12154.
Which puzzles me, since I'm using the connectionstring from my TNSNAMES.ora file:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myPC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
As follows:
private string connectionString = "Data Source=(DESCRIPTION ="
+" (ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = myPC)(PORT = 1521)))"
+" (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = XE));"
+"User Id=sys;Password=zsxyzabc;";
Any ideas?
