.net - ODP.NET Integrated Security Invalid Connection String Argument -


what missing?

 <add name="test"      connectionstring="data source=test_oracle;integrated security=yes;" />  [argumentexception: 'integrated security' 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 (i using bindingredirect version.)

if take out integrated security , declare user id , password functions correctly. so, know there nothing wrong odp.net.

i don't think odp has integrated security attribute: http://download.oracle.com/docs/html/e10927_01/featconnecting.htm#i1006259

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

to migrate odp.net, remove these attributes if part of microsoft oracleclient connection string.

* integrated security -- set " user id=/" in odp.net connection 

string equivalent operating system authentication.

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

so use user id=/ , see if works

also make sure have sqlnet.ora have "sqlnet.authentication_services = (nts)"


Comments

Popular posts from this blog

python - Scipy curvefit RuntimeError:Optimal parameters not found: Number of calls to function has reached maxfev = 1000 -

c# - How to add a new treeview at the selected node? -

java - netbeans "Please wait - classpath scanning in progress..." -