VB6 ADO AddNew and UpdateBatch Methods

[rmaslanka]

Using VB6 and the Pervasive ODBC driver, I am finding the UpdateBatch method fails after I call the AddNew method to add a row to a table. I receive an error like "[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine]The table is not defined in the dictionary". The UpdateBatch method works after simply editing entries in a form bound by code, but not after AddNew.

Ideas?

Unfortunately, I am much more familiar with Access and MS-SQL apps, so any guidance would be appreciated. I have checked

http://www.pervasive.com/devtalk

but couldn't find a related topic.

Thanks.

 

[Pervasivite]

First, it really matters which Pervasive ODBC version you are using. You should make sure you have the latest Pervasive.SQL 2000i if at all possible. You can apply SP3 to any version of Pervasive.SQL 2000 to update it.

Second, it may be that you are using and old database with old or inaccurate DDFs so you should try these methods on data in the DEMODATA. Also you should run the consistency check in PCC on the database and DDFs you are trying to use.


Third, you should post your query to DevTalk. There are also a couple of papers on ADO and OleDB on the Pervasive site which may help.

Pervasivite