Odbc?

[Tadeo]

Does anyone know if Microsofts DBASE driver for ODBC suitable for modifying offline Miva database files?


Thanks

[Vic - WolfPaw Computers]

I havent tried it - but I wouldnt risk it either.

Use DBFUtils or Foxpro.

[mvmarkus]

Hi Tadeo,

The driver works only for editing records in the database but won't update the indices. So either you reindex manually or you use the ODBC-driver only to manage fields that are not used for the index.

If this is a new application that you are developing, use the new drivers with a real SQL database instead of the old dbIIIs. Mivascript now supports MySQL, PostGreSQL (beta), Oracle and ODBC (beta on *nix). This gives you plenty of options.

Markus

[Tadeo]

If this is a new application that you are developing, use the new drivers with a real SQL database instead of the old dbIIIs.

Markus

I need to modify some data generated by an unsupported module used in our MM4 system. Is the database dbaseIII? For some reason, I was under the impression that it was dbaseIV.

[mvmarkus]

I need to modify some data generated by an unsupported module used in our MM4 system. Is the database dbaseIII? For some reason, I was under the impression that it was dbaseIV.

As far as I remember, these are dbIII tables. However, the indices are proprietary (Miva Corp's very own invention), meaning they are not updated when you edit the records. The ODBC driver doesn't know them and doesn't know what to do with them.

So either you run an MvREINDEX on all existing indices after you edited the table, or you reimport the data, if this is possible.

Markus

[Tadeo]

Cool. Thanks.

Just one more question. Would packing the table rebuild the associated indexes?

[mvmarkus]

Cool. Thanks.

Just one more question. Would packing the table rebuild the associated indexes?

Yes, but make sure that you open the table together with all indices. Indices that aren't open during the packing won't be reindexed.

Markus