• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 569
  • Last Modified:

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!!!
0
imby
Asked:
imby
1 Solution
 
aleshCommented:
Perhaps set bigger timeout period, this could help.
0
 
twardCommented:
You may be able to get better error descriptions if you include the following in an errorhandler:

Dim errLoop As Error

For Each errLoop In Errors
       
   Call MsgBox("Error #" & errLoop.Number & ":  " & errLoop.Description, vbCritical + vbOKOnly, "Error")
     
Next errLoop

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now