failure of the underlying provider of open on connecting to .mdf file

Question

i'm tring to publish my desktop application (Winform application) that i used SQL SERVER 2008 on development. So befor set a setup project to my application i create an "App_Data" folder on my application and copy the .mdf file on it

then i modifier the connectionstring on "App.Config" file like this

<add name="ApplicationPCLMEntities" connectionString="metadata=res://*/Model.PCLM.csdl|res://*/Model.PCLM.ssdl|res://*/Model.PCLM.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\ApplicationPCLM.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient"/>

I'um using EntityFramework

so when i run the application i get this error

failure of the underlying provider of open

(LocalDb) is installed on the "target" Computer ? – Cyril Iselin May 21 '16 at 11:35 — Cyril Iselin, May 21 '16 at 11:35
no i have MSSQLSERVER installed – Mokhtar_Nebli May 21 '16 at 11:41 — Mokhtar_Nebli, May 21 '16 at 11:41
In your connection string I read: Data Source=(LocalDb) – Cyril Iselin May 21 '16 at 11:48 — Cyril Iselin, May 21 '16 at 11:48
What is the edition of installed SQL Server? – Reza Aghaei May 21 '16 at 12:02 — Reza Aghaei, May 21 '16 at 12:02

Budhathoki Bijay · Answer 1 · 2016-05-21T11:58:42.137

0

if you are using local db then there is no need for creating appdata folder because it is already present in there instead try

  <add name="ApplicationPCLMEntities" connectionString="Data Source=.; Initial Catalog=ApplicationPCLM ;Integrated Security=True" providerName="System.Data.SqlClient"/>

edited May 21 '16 at 11:58

answered May 21 '16 at 11:48

Budhathoki Bijay

1
3

the problem i want to create an .exe file and attach the mdf file to it – Mokhtar_Nebli May 21 '16 at 11:57

failure of the underlying provider of open on connecting to .mdf file

1 Answers1