Visual Studio 2013 and Oracle 11g express : how to connect? -
i'm trying reach oracle database through visual studio server explorer. i've installed oracle 11g express edition , i've downloaded sql developer tool. default, "system user" created , we've give password , did it.
when comes connect db via vs 2013, choose oracle provider , i'm asked enter server name, username , password. guess username , password system credentials server name? how can find it? xe default? because when i'm trying that, i'm getting error :
ora-12154: tns: not resolve connect identifier specified
thanks help.
it's expecting oracle net setup i.e. tnsnames.ora clients , listener.ora server.
use oracle net manager set these up.
or use thin driver , connect directly listener (usually port 1521)
http://www.oracle.com/technetwork/developer-tools/visual-studio/overview/index.html
Comments
Post a Comment