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.
[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..
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.