.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
Post a Comment