Cannot find correct connection string

Nazneen Sayed

9y1k

Hi,

i have this C# project in visual studio 2015 backend SQL Server 2014.
when i try to run on another PC the connection string wont work.i googled and found

Hide Copy Code

"https://www.connectionstrings.com/sql-server-2014/"

helpful but i dont know what i am doing wrong.

What I have tried:

Hide Copy Code

the connection string which works fine on my machine is :     string str = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\xpert\Documents\RFID_DB.mdf;Integrated Security=True;Connect Timeout=30";


i have installed and updated correct version of SQL on Client PC.Please help me with the correct connection string

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Accepted answer
Is the mdf path exists on the client PC. I am quite sure that it doesn't,

C:\Users\xpert\Documents\RFID_DB.mdf

Recheck the path and it will resolve your issue
Nazneen Sayed9y ago
yup i changed path to common files and it worked. Thanks
Nazneen Sayed9y ago
yes i am triying by all these references already but i get error
A database with the same name exists, or specified file cannot be opened, or it is located on UNC share
Jitendra Shekhawat9y ago
https://www.connectionstrings.com/sql-server/

https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx

http://www.dofactory.com/reference/connection-strings

Cannot find correct connection string

A database with the same name exists, or specified file cannot be opened, or it is located on UNC share