I'm updating a table residing in AS400 and I'm using ODBC to do this. I made a small program to narrow down my source of error and I came to a conclusion that IT JUST STOPS updating on the 254th record ALL THE TIME. I get the error : Run-time error '3000'; Reserved error(-7711); there is no message for this error. Ran the program once again and I get Run-time error '3146'; ODBC - call failed.
Is there like a barrier somewhere on the ODBC settings that I need to increase to solve this problem. I got like 35000 records to update on one run!!!