Getting error while binding exe

Question

hello all, i am using C# windows application with sql database connection.now my need is i want to bind database with setup file. its working fine on my pc but when i deliverd exe to client it getting error localdatabase runtime error occurred the specified LocalDB does not exist. how to fix this error

Jignesh Kumar · Answer

Hi Archit, You have to install same SQL server version in client machine which you have in your local machine.

Jignesh Kumar · Answer

Hi Archit, If you need to open and mdf, you need a SQL instance Do you have SQL instance where you have put your project ? otherwise you need to install it in that system. https://stackoverflow.com/questions/2054905/connecting-to-sql-server-database-mdf-file-without-installing-sql-server-on-clie

Archit Shrivastava · Answer

Sir this is totally offline project. can we create or host application or .udl file offline?

Jignesh Kumar · Answer

Hi Archit, You need to change this path. Data Source= .\SQLEXPRESS; AttachDbFilename=|DataDirectory|\ITBPLOCAL.mdf;Integrated Security=True" providerName="System.Data.SqlClient" What you can do create .udl file in client where you are hosting application double click on it then provide server details select database then test connection. once scucced then you can check inside file your connection string you can verify there and compare above code in both.

Archit Shrivastava · Answer

Hello jignesh sir, i am using this connection string connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\ITBPLOCAL.mdf;Integrated Security=True" providerName="System.Data.SqlClient" /> but this is not working on client pc.

Jignesh Kumar · Answer

Hi Archit, Its config error where ever you have used your connectionstring to connect your database you need to change your App.config or if you are using web.config file then there. Check connection string in App.config file "YourconnctionstringName" connectionString= "Yourclint databse related changes" />