由网友(多情应笑我)分享简介：我在想什么？[ArgumentException: 'Integrated Security' is an invalid connection...

我在想什么？

<add name="test" 
    connectionString="Data Source=TEST_ORACLE;Integrated Security=Yes;" />

[ArgumentException: 'Integrated Security' is an invalid connection string attribute]
   Oracle.DataAccess.Client.OracleConnection.ParseConnectionString() +2707
   Oracle.DataAccess.Client.OracleConnection.set_ConnectionString(String value) +533
   Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString) +210

ODP.NET：Oracle.DataAccess - 2.102.2.20（我使用的是bindingRedirect到这个版本）

ODP.NET: Oracle.DataAccess - 2.102.2.20 (I am using a bindingRedirect to this version.)

如果我走了集成安全性声明的用户名和密码，然后将它正常工作。所以，我知道有没有错ODP.NET。

If I take out Integrated Security and declare User ID and password then it functions correctly. So, I know there is nothing wrong with ODP.NET.

推荐答案

我不认为ODP具有集成安全特性： http://download.oracle.com/docs/html/E10927_01/featConnecting热媒＃i1006259

I don't think that ODP has the Integrated Security Attribute: http://download.oracle.com/docs/html/E10927_01/featConnecting.htm#i1006259

但本网站（http://www.oracle.com/technetwork/topics/dotnet/$c$c-154692.html）  州

but this site (http://www.oracle.com/technetwork/topics/dotnet/code-154692.html) states

要迁移到ODP.NET，除去这些   属性，如果他们的一部分   微软OracleClient的连接   字符串。

To migrate to ODP.NET, remove these attributes if they are part of the Microsoft OracleClient connection string.

* Integrated Security -- Set " User Id=/" in the ODP.NET connection

     

字符串相当于操作   体系认证。

string for the equivalent operating system authentication.

这是相同的，这些人经历： HTTP： //forums.oracle.com/forums/thread.jspa?threadID=583813&tstart=405

which is the same that these guys go through: http://forums.oracle.com/forums/thread.jspa?threadID=583813&tstart=405

所以，使用用户ID = / 并看看是否能工程

So use User Id=/ and see if that works

也确保有你的sqlnet.ora中有SQLNET.AUTHENTICATION_SERVICES =（NTS）

also make sure to have your sqlnet.ora have "SQLNET.AUTHENTICATION_SERVICES = (NTS)"