Old NotesNut 1.Feb.10 02:17 PM a Web browser Connector for DB2 LEI - 6.0 Windows
I have a Virtual Document Activity for which we wish to save the data to dB2. We have tested the dB2 connection and table using a temporary form in Notes that has all of the fields the production form will have and mapped them to the appropriate columns in dB2... the Test form works fine, but, when we try to activate the production form we get this error message:
02/01/2010 01:01:53 PM Monitor failure -- Error: Realtime service error scanning the external system. Some external records may have been ignored (1717)
02/01/2010 01:01:53 PM Monitor failure -- Error: [IBM][CLI Driver][DB2] SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007, Connector 'db2', Method -Select- (-180)
There is only one date/time field on the form and as mentioned above, when used with our test form the column is populated as expected with date and time. (dB2 timestamp type) .. and the db2 column EIMODIFIED TIMESTMP 10
The datetime error appears to be generic ... and possibly not related to the "real" underlying problem ... help?