sql Connection .mdf Erorr

[Ashen_Boy]

I'm coding project Using MS Visual Studio 2017 to enter data to sql Database. when i'm publish the project to another pc its can't connection to sql database show error like image below . the connection string =

SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|Car_db.mdf;Integrated Security=True");

C#

 

[jmcilhinney]

The |DataDirectory| replacement pattern doesn't include a trailing slash, so you need to include one in your connection string:

SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Car_db.mdf;Integrated Security=True");

That said, I don't think that things are even getting that far because I think that that would generate a different error message. There appears to be an issue with your LocalDB instance. Not something I've seen before but this may be helpful.

 

[Skydiver]

when i'm publish the project to another pc

Does your publishing include a setup program to install SQL Server Express on the other machine as well?

 

[Ashen_Boy]

The |DataDirectory| replacement pattern doesn't include a trailing slash, so you need to include one in your connection string:

SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Car_db.mdf;Integrated Security=True");

That said, I don't think that things are even getting that far because I think that that would generate a different error message. There appears to be an issue with your LocalDB instance. Not something I've seen before but this may be helpful.

same Error !!!

 

[Ashen_Boy]

Does your publishing include a setup program to install SQL Server Express on the other machine as well?

How Can I do this

 

[Skydiver]

SQL Server Express LocalDB - SQL Server

Become familiar with SQL Server Express LocalDB. Developers can use this lightweight Database Engine for writing and testing Transact-SQL code.

learn.microsoft.com

 

[JohnH]

Click the Prerequisites button in Publish tab, there should be a SQL Server Express LocalDB option.

 

[jmcilhinney]

same Error !!!

Why are you surprised, given that I specifically stated that I didn't think that the cause of your issue?