Syntax error (missing operator) in query expression c#

Question

Can some one please help me to resolve the issue ?

I am getting the syntax error while running this code.

OleDbConnection cn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=J:\CADFileLogger.accdb");
string cmdText = "INSERT INTO [tbl_Logger] (Username,FullFileName,DateOfAction,EventMode,ShortFileName) VALUES (@a,@b,@c,@d,@e)";

cn.Open();

OleDbCommand cmd = new OleDbCommand(cmdText, cn);
cmd.Parameters.Add("@a", OleDbType.WChar).Value = username;
cmd.Parameters.Add("@b", OleDbType.WChar).Value = fullfilename;
cmd.Parameters.Add("@c ", OleDbType.DBTimeStamp).Value = now;
cmd.Parameters.Add("@d ", OleDbType.WChar).Value = mode;
cmd.Parameters.Add("@e ", OleDbType.WChar).Value = filename;

cmd.ExecuteNonQuery();

cn.Close();

Could it be that Username is a reserved word or function? I'm just guessing really. — Lasse V. Karlsen
– Lasse V. Karlsen, Commented May 12, 2022 at 7:35
This is a great example of where the precise error details - and the fact that it was a compilation error rather than an exception - would have been useful to include in the question. It's entirely feasible for SQL to have a syntax error, but knowing that it was a compilation error would have ruled that out as being the immediate problem. — Jon Skeet
– Jon Skeet, Commented May 12, 2022 at 7:41

Jon Skeet · Accepted Answer · 2022-05-12 07:40:12Z

1

The problem is the backslash in the data source:

OleDbConnection cn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=J:\CADFileLogger.accdb");

Either put an @ in front of the connection string or escape the backspace:

OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=J:\CADFileLogger.accdb");

edited May 12, 2022 at 7:40

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

answered May 12, 2022 at 7:37

diiN__________

7,7197 gold badges49 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

Syntax error (missing operator) in query expression c#

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