I’m trying to read (via disconneted ado recordset class) and update dBase III Plus table with a VB6 (SP5, MDAC 2.7, BDE installed) project. It reads disconnected recordset in OK, but while doing loop through recordset to update fields via “update tbl set fld =” statements, after a random number of updates, it produces this error
Run-time error "7":
Error executing statement! Error:[Microsoft][ODBC dBase
Driver] System resource exceeded.
Yet moments before a crash System Resources look fine at 68% in a concurrently running Stress app. etc.
In addition, the only connection strings that I’ve gotten to ‘work’ at all are bare bones ones such as
"MSDASQL.1;Data Source=dBASE Files; Initial Catalog=" & theDataDirPath
Adding more parameters (like DriverID= , etc ) produces
Run-time error '3706':
Error opening connection! Error: Provider cannot be
found. It may not be properly installed.
which and ETC. did not fix.
I have a stripped project, data, and short doc in a small zip that I can forward to you if you need to replicate this or see if it works on your system. Please just ask for it at and direct requests for further info to ej.cutshall@icsweb.com
My suspects are MS data access / ODBC / dll’s (clued by the adofix above) / my connection strings and methodology (but the class has always worked perfectly in Jet 35 and Jet40). Any help or direction you can provide would be greatly appreciated.
EJ
Run-time error "7":
Error executing statement! Error:[Microsoft][ODBC dBase
Driver] System resource exceeded.
Yet moments before a crash System Resources look fine at 68% in a concurrently running Stress app. etc.
In addition, the only connection strings that I’ve gotten to ‘work’ at all are bare bones ones such as
"MSDASQL.1;Data Source=dBASE Files; Initial Catalog=" & theDataDirPath
Adding more parameters (like DriverID= , etc ) produces
Run-time error '3706':
Error opening connection! Error: Provider cannot be
found. It may not be properly installed.
which and ETC. did not fix.
I have a stripped project, data, and short doc in a small zip that I can forward to you if you need to replicate this or see if it works on your system. Please just ask for it at and direct requests for further info to ej.cutshall@icsweb.com
My suspects are MS data access / ODBC / dll’s (clued by the adofix above) / my connection strings and methodology (but the class has always worked perfectly in Jet 35 and Jet40). Any help or direction you can provide would be greatly appreciated.
EJ
