Visual Basic Built in database Connection String Syntax Error

Question

I am using the built-in database for my program. When I try to put in the connection string, VB cannot detect the connection string and shows a syntax error on line 7 after the new SqlConnection. I am sure that I copied the complete connection string from the properties page.

I read this post but it seems to be a different question. Below is my code for the connection. Is there any mistake in my code? Thanks for all the help!

    Imports System.Data.SqlClient 
    Public Class Login
    Dim cmd As SqlCommand
    Dim dr As SqlDataReader
    Dim da As SqlDataAdapter
    Dim sql As String
    Dim conn As SqlConnection = New SqlConnection("Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename="C:\Users\zhenwei\source\repos\Cafeteria Ordering System v1.0\Cafeteria Ordering System v1.0\Database1.mdf";Integrated Security=True")

jmcilhinney · Accepted Answer · 2020-05-01 05:06:13Z

1

That'll obviously show you a syntax error, look at your following line:

"C:\Users\zhenwei\source\repos\Cafeteria Ordering System v1.0\Cafeteria Ordering System v1.0\Database1.mdf"

Replace the double-quotes to ""<abc>"" to get like "<abc>" on execution because you've already used "<abc>" in New SqlConnection("...").

Rather than:

Dim conn As SqlConnection = New SqlConnection("Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename="C:\Users\zhenwei\source\repos\Cafeteria Ordering System v1.0\Cafeteria Ordering System v1.0\Database1.mdf";Integrated Security=True")

you should have:

Dim conn As SqlConnection = New SqlConnection("Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=""C:\Users\zhenwei\source\repos\Cafeteria Ordering System v1.0\Cafeteria Ordering System v1.0\Database1.mdf"";Integrated Security=True")

edited May 1, 2020 at 5:06

jmcilhinney

54.9k5 gold badges30 silver badges52 bronze badges

answered May 1, 2020 at 4:54

Rohan Bari

7,7393 gold badges18 silver badges42 bronze badges

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

2 Comments

Sukasa Over a year ago

Dim conn As SqlConnection = New SqlConnection("Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=""C:\Users\zhenwei\source\repos\Cafeteria Ordering System v1.0\Cafeteria Ordering System v1.0\Database1.mdf"";Integrated Security=True") When I do what you suggest the system just recognise the whole line as text.

jmcilhinney Over a year ago

@Sukasa, the whole line is not recognised as text, but the everything within the parentheses is recognised as a single String, which is what should be the case. You can even see it in the syntax parser on this site. In your question, the file path part of your connection string is white, because it is not recognised as part of the String. If you double up the double-quotes then the whole lot is the same colour because it is recognised as a single String literal. The same happens in VS. I have added an edit to this answer that shows just that.

Collectives™ on Stack Overflow

Visual Basic Built in database Connection String Syntax Error

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related