CODEWITHSUNDEEP
c#sql-servervisual-studio-2010connection-string
Herman Vercuiel
Herman Vercuiel

Reputation: 69

ERROR: Unknown connection option in connection string: attachdbfilename

Cant seem to get my connection string to work.

app.config file:

<add name="PalisadeWorld.Properties.Settings.PalisadeWorldDatabaseConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\PalisadeWorldDatabase.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

Where I use the connection string:

  SqlCeConnection Con = new SqlCeConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=&quot;C:\\Users\\Win8User\\Documents\\Visual Studio 2010'Projects\\PalisadeWorld\\PalisadeWorld\\PalisadeWorldDatabase.mdf&quot;;Integrated Security=True;User Instance=True");

I've tried almost everything I could think of or find online.

I keep getting the error:

Unknown connection option in connection string: attachdbfilename.

Am I missing something?

Thank your for you time

Upvotes: 0

Views: 2853

Answers (2)

Herman Vercuiel
Herman Vercuiel

Reputation: 69

Turns out I was not using the compact version of SQL (SqlCeConnect)

so I need to use SqlConnect instead

SqlConnection Con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\PalisadeWorldDatabase.mdf;Integrated Security=True;User Instance=True");

Thanks everyone, Kindly

Upvotes: 1

Shafqat Masood
Shafqat Masood

Reputation: 2570

Template for connection string is 

<add name="TrempimModel"
 connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;
                   database=YourDatabaseName;
                   AttachDBFilename=|DataDirectory|aspnetdb.mdf;
                   User Instance=true"
 providerName="System.Data.SqlClient" />

please remove '\' from the attachdbfilename attibute after datadirectoy so new connectionstring will be 

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

and when getting connection string use.

 SqlCeConnection Con = new SqlCeConnection(ConfigurationSettings.AppSettings["PalisadeWorldDatabaseConnectionString"].ToString());

Upvotes: 0

Related Questions