Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

[MySQL][ODBC 3.51 Driver][mysqld-3.23.49-nt]You have an error in your

Status
Not open for further replies.

chints

Programmer
Nov 4, 2002
2
US
Hey guys., i am trying to do a simple addnew, update and i am getting this error.,can any one help me out please.

This is the code thats causing the error:

sql2="select * from dattbl_reports"
rs2.Open sql2,conn,3,3
rs2.AddNew
->rs2.Update

Error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-3.23.49-nt]You have an error in your SQL syntax near 'DEFAULT VALUES' at line 1

syntax near 'DEFAULT VALUES' at line 1

Thanks in advance!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top