imby
asked on
ODBC Call Failed Error
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!!!
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!!!
Perhaps set bigger timeout period, this could help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.