locked
Integrated Security problem in Connection string RRS feed

  • Question

  • User-1141190189 posted

    I have the following problem regarding oracle client connection string from .net web service, any help please?

    Error Message: 'integrated security' is an invalid connection string attribute
    Stack Trace:    at Oracle.ManagedDataAccess.Client.ConnectionString.SetProperty(String key, String value, String quotedValue)
       at Oracle.ManagedDataAccess.Client.ConnectionString.Parse(String constr)
       at Oracle.ManagedDataAccess.Client.ConnectionString..ctor(String constring)
       at Oracle.ManagedDataAccess.Client.ConnectionString.GetCS(String constr)
       at Oracle.ManagedDataAccess.Client.OracleConnection.set_ConnectionString(String value)
       at Oracle.ManagedDataAccess.Client.OracleConnection..ctor(String connectionString)
       at MyCode.DataAccess.Repository.insert(Company oCompany)

    the connection string is 

    <add connectionString="Persist Security Info=False;Integrated Security=False;Password=123;User ID=USER1;Data Source=testDB" name="ConnectionString" providerName="Oracle.DataAccess.Client" />

    Wednesday, April 4, 2018 10:51 AM

All replies

  • User753101303 posted

    Hi,

    I'm not using Oracle but by first move would be to check the doc to see if it is supported with what you are using. What if you just omit this from your connection string ?

    According to https://docs.oracle.com/cd/B28359_01/win.111/b28375/OracleConnectionClass.htm#BABBAGJJ it seems just not supported (you likely took that from a SQL Server connection string).

    Wednesday, April 4, 2018 12:51 PM
  • User269602965 posted

    Try

      <connectionStrings>
        <add name="OraConnStr" connectionString="Data Source={YOUR_ORACLE_SID};Persist Security Info=True;User Id={SCHEMA};Password={Password}" providerName="Oracle.DataAccess.Client">
        </add>
      </connectionStrings>

    Wednesday, April 4, 2018 5:24 PM