System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误
Conn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("test.mdb");
string myConn="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"./db/ask.mdb;";
OleDbConnection conn=new OleDbConnection(myConn);
OleDbCommand cmd=new OleDbCommand ("insert into login(username,password)values('test','test')",conn);
cmd.open();
cmd.ExecuteNonQuery();
conn.Close();
System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误
update语句也会出错,SQL和MYSQL中同样语句就没问题哦.
好像是ACCESS自身的问题,怎么解决啊,谢谢