Hi @Jim Longlade ,
"Command parameter[0] '' data value could not be converted for reasons other than sign mismatch or data overflow.
This problem is caused by a mismatch between the format of the data and the format in the database.
'Microsoft.ACE.OLEDB.12.0' failed with no error message available, result code: E_OUTOFMEMORY(0x8007000E).
This can occur if the program is attempting to allocate too much memory, or if there is insufficient memory available on the system to meet the program's requirements.
Based on your problem description, it's possible that the application is running out of memory due to the limitations of the 32-bit architecture.
32-bit applications are limited to using a maximum of 2GB of memory, which can lead to out-of-memory errors when working with large datasets or performing memory-intensive tasks.
If you encounter both problems, it is recommended that you replace the long format in the database with the Integer format to reduce the memory footprint and match the int format in your code.
Best Regards.
Jiachen Li
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.