Solved

ODBC Call Failed Error

Posted on 1998-11-23
2
557 Views
Last Modified: 2012-08-13
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
Comment
Question by:imby
2 Comments
 
LVL 1

Expert Comment

by:alesh
ID: 1446289
Perhaps set bigger timeout period, this could help.
0
 
LVL 7

Accepted Solution

by:
tward earned 100 total points
ID: 1446290
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

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem to skip loop 6 57
Best way to parse out a json string in VB6? 10 165
Zip Folders Using Chilkat Routines 1 39
IF ELSE Statement in Excel Macro VBA 16 63
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question