Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB ado to dBase III Plus

Status
Not open for further replies.

Zro

Programmer
Mar 2, 2002
4
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top