Skip to content
Ask A Question
  • There are no suggestions because the search field is empty.

OPC Data Logger Error - Syntax error in INSERT INTO statement. Requesting Shutdown.

I am using the OPC Data Logger. When I start logging I get the following error:
Syntax error in INSERT INTO statement.  Requesting Shutdown.
How can I solve this?

This error is occurring because your database table or column names are invalid for use in a SQL statement or invalid for your database engine.  There are  three possible reasons a table or column name can be invalid:

  • Using a reserved word as a table or column name.
    Most databases have a set of reserved words.
    For example, "date" or "timestamp" are reserved words and cannot be used for column names in a database.
  • Using special characters in the name. These special characters include:

    . / * : ! # & - ?

  • Using a space in the name.

To fix the problem, avoid using reserved words when specifying table and column names in your database. 

Also, eliminate spaces and special characters.

See the following web pages for lists of reserved words for common database systems: