CODEWITHSUNDEEP
foxprovisual-foxproadvantage-database-server
Feuerwehrler
Feuerwehrler

Reputation: 51

Error in ADS OleDB when inserting data into VFP Database?

I need some help with the ADS OleDB Provider for Visual FoxPro.

I'm trying to insert data from an 64-Bit .net-Application into a FoxPro Database. The table in which the data will be inserted has about 130'000 records, 139 fields and 11 indexes. Every time I run my sample application i get an error which says that the indexes are corrupted after only 3 or 4 inserted records.

If I use a smaller table to insert some sample data there is no problem with corrupted indexes.

Does someone know this problem and has found out a way to solve it?

Thanks!

Upvotes: 0

Views: 543

Answers (1)

DRapp
DRapp

Reputation: 48139

VFP doesn't support 64-bit --- PERIOD... However, why not use the direct VFP OleDb provider. I've used it for years and haven't really encountered any issues with all types of queries, insert, updates, deletes, and even ExecuteScript() calls.

Clarification...

Have you tried using VFP's OleDB provider instead of ADS? I'm sure it still has similar objects derived from similar interface objects such as...

Ole Db Object    Common interface
---------------- -----------------
OleDbConnection  IDbConnection
OleDbParameter   IDbDataParameter
OleDbCommand     IDbCommand
OleDbDataAdapter IDbDataAdapter
OleDbException   IDbException

Upvotes: 1

Related Questions