Error 440 when reading an Access DB
From Support
| If you have a question or seek clarification, please call Technical Support. |
[edit]
Problem:
When running the RPG2SQL Integrator and reading an Microsoft Access database we would get the following error in debug mode:
Received Delimited Record: , from 10.1.1.8(996) Sending: 100 SQL 999 ERR440 Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. 199 EOF
[edit]
Solution:
The Access database had a field defined as Date/Time. If nothing has been set in that field, when you view the database in Access it will show a default date and time even though there is nothing actually in the field. When we try to read the field we would read it back as a NULL value.
Upgrade the RPG2SQL Integrator PC component to version 1.0.35 or above. Now the date/time field will return the default value instead of NULL.
