Oracle ORA-12154: TNS:could not resolve the connect identifier specified(不积跬步 无以至千里)

ORA-12154: TNS:could not resolve the connect identifier specified

在网上也找了些方法,但没有解决我的问题.

之前sql环境同步里是: <add name="TargetConnectionString" connectionString="server=******;database=***;User ID=***;Password=***;"

providerName="SqlServer" />

oracle环境是这个 <add name="TargetConnectionString" connectionString="Server=***;User Id=***;Password=***;"

providerName="Oracle" />

正是上述的问题暴露出那种错误. 将server修改为Data Source就好了~~

<add name="TargetConnectionString" connectionString="Data Source=***;User Id=***;Password=***;"

providerName="Oracle" />