Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    23

    Unanswered: Reserved Error (-3034) execution halts in between

    I am using VB6, on windows XP and using ODBC to connect to DB2 Database on database server internal network. I need to retrieve around 4000 - 5000 records and display information in Rich Text Box (RTB) on VB6 form. When I executes the program, it runs well for sometime and displays around 3000- 3500 records in RTB, then after some time it gives me following error.


    Run-time error'-2147467259(80004005)';

    [Microsoft][ODBC dBase Driver] Reserved Error (-3034); there is no message for this error.

    When I press "DEBUG" button on message error box, it points to 2nd line of following code

    strqueryAddrCust = "SELECT CUSTOMER from CUST where CUST_ID = '" + CStr(CustID) + "'"

    Set localrecordsetAddrCust = AGFDB.CONAGF.Execute(strqueryAddrCust)
    totalRecCountAddrCust = localrecordsetAddrCust.RecordCount

    but goes through well while doing single stepping (F8) and executes well . It just stops sometimes.

    When I copy the same database on my local host and map network drive to it, code runs perfectly fine without any error.

    Please let me know what mght be the possible cause of this error...and any suggestions..

    regards,

    Anurag Gupta
    Last edited by anuindia; 03-30-04 at 19:42.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    According to the error message, the problem is in the ODBC driver for DBF files. It appears that there is a problem with the virtual directory that contains the DBF file itself. I suspect that the problem occurs after reading about 512 Kb of data, which is when the data buffer tries to refresh, which is often foiled by the way that XP handles remote file access.

    I would strongly suggest loading the data from the DBF file to the DB2 server. That should eliminate this problem.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •