I am connecting to an MS SQL server. I can read, update records no problem, but as soon as I try to add a row I am unsuccessful.
If I perform an ODBResultSet.AddRow(), then .SetValue(“”, “” ), no errors occur. If I loop accross row prior to result.UpdateRow(), all appears OK.
The error I am receiving is: LS:DO- ODBC could not complete the requested operation. The error number is 500.
I have tried using the .SetValue() method and building my SQL string and running an .execute(). Running the SQL.execute() does ont raise any errors, but does not appear to be commiting the data to the destination SQL db, if you run a subsequent check for that record, it does not exist.
I have tried changing the configuration of the driver, but don’t see much to change there. I asked the admin of the DB, the connection credentials have full CRUD access.
Field map data types all appear correct.
I’ve slightly run out of ideas, does anyone have any comments\ suggestions?
Nick