'Unicode' is an invalid connection string attribute Asp.net

Question

My code have error ---- 'Unicode' is an invalid connection string attribute

Web Config :

<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=XE;Persist Security Info=True;User ID=****;Password=****;Unicode=True"
  providerName="System.Data.OracleClient" /> </connectionStrings>

Asp.net:

 public DataTable Bankomat(DataTable dt)
    {

        using (con = new OracleConnection())
        {
            using (cmd = new OracleCommand())
            {
                con.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ToString();

                cmd.Connection = con;
                cmd.CommandText = "select * from bankomat";
                con.Open();
                dt.Load(cmd.ExecuteReader());
                con.Close();
            }

        }
        return dt;
    }

Your code have not error. Your config have error. Also, it looks like you're trying to revive an ancient version of ASP.NET, so please have a look at asp.net/get-started for how you can do ASP.NET these days. — bzlm
– bzlm, Commented Aug 9, 2016 at 11:25

Tsahi Asher · Accepted Answer · 2020-07-26 09:58:21Z

7

In the connection string

connectionString="Data Source=XE;Persist Security Info=True;User ID=****;Password=****;Unicode=True"

the Unicode=True is belong to System.Data.OracleClient and not to Oracle.DataAccess.Client

So just remove it.

edited Jul 26, 2020 at 9:58

Tsahi Asher

1,83417 silver badges30 bronze badges

answered Aug 9, 2016 at 11:30

Aristos

66.7k16 gold badges117 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

'Unicode' is an invalid connection string attribute Asp.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related