I want to insert data from a old clipper program's database using c#
the database is associated with an .ntx file.
i can insert data using vfpoledb driver to the dbf in my c# program, however, when i look at the old clipper program, the data was not there but it is in the dbf.
the culprit was the .ntx file, it needed to be reindexed so the data would be visible in the clipper program. The reindexing was done by the old program when ever i delete the .ntx files.
how can i insert data and update the .ntx files as well? the old program was not made by me but a past employee here in the company.
You'll need a third-party driver that supports the Clipper .NTX format.
Advantage Database Server from Sybase has .Net data provider, ADO and ODBC drivers that will work, and their local server is free (at least at the time I'm writing this post). The latest versions can be found here. (I'm not affiliated with them in any way; I've just done some porting of old Clipper data.)
The documentation (available both from the downloaded installations and online) contain the entire contents of a commercially published book that contains tutorials and reference materials that will help you get started.
There is a tag for Advantage here, so if you have questions regarding use you can post them using that tag. (Their Data Architect, available from the same site, will let you work with the data and indexes from an IDE as well.)