Oracle.ManagedDataAccess.dll

C#使用Oracle.ManagedDataAccess.dll

System.Data.OracleClient程序集没有多大的不同,基本上拿以前使用System.Data.OracleClient程序集的代码做少许的改动即可。

1、使用了连接字符串,而不是用oracle客户端的服务名了;

2、几个命名空间的变化;

链接字符串:

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.4.10)(PORT =1521)))(CONNECT_DATA=(SERVICE_NAME=hb)));Persist Security Info=True;User ID=hb;Password=hb;

 Flips:

https://www.cnblogs.com/duanjt/p/6955173.html

 【ORA-01017】.NET程序连接数据库失败

https://www.jianshu.com/p/c301b062237b

.NET程序与FIPS兼容性问题

https://www.xiaozhou.net/let_your_dotnet_program_compatible_with_fips-2012-02-17.html

c# - C# Oracle.ManagedDataAccess 和 01017: 用户名/密码无效;拒绝登录

Oracle.ManagedDataAccess and FIPS Compliance

https://community.oracle.com/message/12707861#12707861

ORA-01017 with managed ODP.NET provider when FIPS is enabled

https://community.oracle.com/message/12738172#12738172

当FIPS策略启用时,WiX自定义操作无法连接到数据库

https://stackoverrun.com/cn/q/9607037

原文地址:https://www.cnblogs.com/wangjunwei/p/7841733.html