SQL Login

[clayton74]

Hello All

I am trying to create a form that requires authentication from an SQL login to access

I have a form with a username textbox and a password textbox and I am trying to allow login

' Open a connection by referencing the ODBC driver.
cnn.ConnectionString = "driver={SQL Server};" & _
"server=laptop;uid=username;pwd=password;database=Logging"

I have tried
' Open a connection by referencing the ODBC driver.
cnn.ConnectionString = "driver={SQL Server};" & _
"server=laptop;uid='" & txt_user.Text & "';pwd='" & txt_pass.Text & "';database=Logging"

But get login failed for user "sa"

Any help would be gratefully received

 

[JoeAtWork]

You don't need the single quotes around the username and password.

   cnn.ConnectionString = "driver={SQL Server};" & _
      "server=laptop;uid=" & txt_user.Text & ";pwd=" & txt_pass.Text & ";database=Logging"