Troubleshooting SQL Server connection string for LocalDB

Question

I am working on a C# Windows Forms application, and I'm trying to connect to my local database, which is an attached file.

When I run my project startup the program continues to run without the windows form displaying, and no errors were shown.

After referencing multiple sources, I am still unable to work out a connection string.

Current connection string:

SqlConnection con = new SqlConnection("Data Source=(LocalDB)/MSSQLLocalDB;AttachDbFilename=C:/USERS/RUIHAO.LIM/DOCUMENTS/VISUAL STUDIO 2015/PROJECTS/HASH TESTING/HASH TESTING/TESTDB.MDF;Database=TestDB;Trusted_Connection=Yes;");

Details of my environment:

Name: TestDBConnectionString
Database: C:\USERS\RUIHAO.LIM\DOCUMENTS\VISUAL STUDIO 2015\PROJECTS\HASH TESTING\HASH TESTING\TESTDB.MDF
Server: (LocalDB)\MSSQLLocalDB
User: USER\ruihao.lim

My code snippet:

namespace Hash_Testing
{
    public partial class CreateUser : Form
    {
        public CreateUser()
        {
            InitializeComponent();
        }

        private void CreateUser_Load(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("Data Source=(LocalDB)/MSSQLLocalDB;AttachDbFilename=C:/USERS/RUIHAO.LIM/DOCUMENTS/VISUAL STUDIO 2015/PROJECTS/HASH TESTING/HASH TESTING/TESTDB.MDF;Database=TestDB;Trusted_Connection=Yes;");

            con.Open();
        }
    }
}

linden.phoenix · Accepted Answer · 2018-08-24 09:22:48Z

2

try

Data Source=(LocalDB)\MSSQLLocalDB

or

Data Source=.\MSSQLLocalDB

answered Aug 24, 2018 at 9:22

linden.phoenix

2041 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Troubleshooting SQL Server connection string for LocalDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related