Weird error while using SqlConnection and AttachDbFilename

Question

I'm facing a weird error while trying to connect to an attached DB in my web app.

My connection string:

<add name="ExtJSTestDB" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\KODatatableContext.mdf;User Instance=True;Integrated Security=True;" providerName="System.Data.SqlClient" />

The code in controller:

using (var cn = new SqlConnection("ExtJSTestDB")){...}

Right at the moment of call "new SqlConnection" I get this:

Exception thrown:

'System.ArgumentException' in System.Data.dll Additional information: Das Format der Initialisierungszeichenfolge stimmt nicht mit der Spezifikation überein, die bei Index '0' beginnt.

What am i doing wrong?

Please add a language tag and a tag for the database you try to connect to. — AbcAeffchen
– AbcAeffchen, Commented Jul 6, 2018 at 13:33
Possible duplicate of error message: Format of the initialization string does not conform to specification starting at index 0 (same problem and exception but with the error message in English). — Lance U. Matthews
– Lance U. Matthews, Commented Jul 8, 2018 at 20:37

D-Shih · Accepted Answer · 2018-07-08 20:26:56Z

2

If your connectionString in Web.config xml element connectionStrings`

  <connectionStrings>
    <add name="ExtJSTestDB" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\KODatatableContext.mdf;User Instance=True;Integrated Security=True;" providerName="System.Data.SqlClient" />
  </connectionStrings>

You can't use name="ExtJSTestDB" to set connection string,You need to use System.Configuration.ConfigurationManager.ConnectionStrings Concollection to read ConnectionString data.

string connStr= System.Configuration.ConfigurationManager.ConnectionStrings["ExtJSTestDB"];
using (var cn = new SqlConnection(connStr)){...}

answered Jul 8, 2018 at 20:26

D-Shih

46.5k6 gold badges38 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

Weird error while using SqlConnection and AttachDbFilename

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related