Syntax error in INSERT INTO statement

Question

 Dim sqlstr As String = ("insert into users (username, password) values('bb','ss')")
 comand = New OleDb.OleDbCommand(sqlstr, con)
 If con.State() Then con.Close()
    con.Open()
    comand.Connection = con
    comand.ExecuteNonQuery()
 End If

Also: don't store passwords in plaintext. And don't treat State() like a boolean, It's an Enum. — Mitch Wheat
– Mitch Wheat, Commented Nov 25, 2014 at 0:01
You do not mention the whole error message, which should give a clue, but password is a reserved keyword. If this is MSSQL, use insert into [users] ([username], [password]) values('bb','ss') — eckes
– eckes, Commented Nov 25, 2014 at 0:10

OneFineDay · Accepted Answer · 2014-11-25 00:05:35Z

0

User is a keyword. Depending on the db Users might be, so try:

Dim sqlstr As String = ("insert into [dbo].[users] (username, password) values('bb','ss')")
comand = New OleDb.OleDbCommand(sqlstr, con)
If con.State() Then con.Close()
  con.Open()
  comand.Connection = con
  comand.ExecuteNonQuery()
End If

Also do not store the UN/PW as plain text.

answered Nov 25, 2014 at 0:05

OneFineDay

9,0344 gold badges28 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

Syntax error in INSERT INTO statement

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related