最近让这个问题困扰了我很长时间,原因终于找到了。
原先的数据:
<add key="constrOrcl" value="Data Source =(DESCRIPTION =(ADDRESS=(PROTOCOL=TCP)(HOST =IP地址)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DEDICATED)(SID =archprd1))); User Id = **; Password=****;"/>
现在的数据:
<add key="constrOrcl" value="Data Source =(DESCRIPTION =(ADDRESS=(PROTOCOL=TCP)(HOST =IP地址)(PORT=1521))(CONNECT_DATA=(SID =archprd1))); User Id = ****; Password=****;"/>
去掉了(SERVICE_NAME=DEDICATED)它就可以了。