I am not able to established conenction to oracle throught oracle managed dataaccess client from my windows 7 64 bit machine.I am using asp.net 4.0 and visual studio 2013.
My web config has this settings or oracle:
<oracle.manageddataaccess.client>
<version number="4.121.1.0">
<!--<dataSources>
<dataSource alias="abc" descriptor="(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = asd.dd.dsd.va.us)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = (SID=abc)))" />
</dataSources>-->
<settings>
<setting name="TNS_ADMIN" value="D:\oracle\product\12.1.0\client_1\Network\Admin"/>
</settings>
</version>
</oracle.manageddataaccess.client>
I am getting above error at con.open step of code :
string connString = "User Id=aaa;Password=ccc;Data Source=(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = asd.dd.dsd.va.us)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = (SID=abc)));";
OracleConnection con = new OracleConnection();
con.Open();
oraCmd = con.CreateCommand();
oraCmd.CommandText = _strSQL;
OracleDataReader reader = oraCmd.ExecuteReader();