INSERT INTO SOMESERVER...[SomeTable] ([ID], [Timestamp]) VALUES (746, 1504500000)
This statement is missing delimiters for the identifiers in an ODBC trace.
"INSERT INTO SomeTable ( ID,Timestamp) VALUES(?,?)"
Therefore the statement results in an error due to the reserved word
Timestamp. How can we add the required delimiters?
- Microsoft SQL Server Express (64-bit) Version 12.0.5207.0
- Microsoft OLE DB Provider for ODBC Drivers
- 4D v13 ODBC Driver 64 bits
Update: as a workaround, we created a service to insert the missing delimiters by intercepting the network communication between the ODBC driver and the 4D database.