Syntax error in INSERT statement

[K Vidhyakar]

 
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:company","","");
stat=con.prepareStatement("Insert into timeCard (eid,ename,timeIn,timeOut,date,status) values(?,?,?,?,?,?)");
 

stat.setString(1,"er");
stat.setString(2,"rwer");
stat.setString(3,"ee");
stat.setString(4,"ee");
stat.setString(5,"ee");
stat.setString(6,"ws");
 
stat.executeUpdate();
con.commit() ;
stat.close();
con.close();
}
catch(Exception e) {
System.out.println("Excepion occured ! "+e);
}
   

im getting syn
"java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driv
er] Syntax error in INSERT INTO statement."

while running the above. code. any body help me with this problem
[ July 21, 2006: Message edited by: K Vidhyakar ]

[Zip Ped]

Check your field data types (such as eid,timeIn, timeOut). Are all your field of the type Text in your table?

[Paul Clapham]

"Date" is a reserved word in MS Access (which I guess you may be using) and probably in other databases too. Changing the column name to something more precise would, as a side effect, improve your database design.

[K Vidhyakar]

they i changed the field name date to edate. now its working.
thanks a lot friends.

[amit bhadre]

check the DNS name which should be created as company while connecting to MS sql server.