I'm trying to read data from an Advantage Database with Advantage .Net Data Provider. When I execute my app, I have the following error :
"Error 5175 the index was created with a different collation sequence"
A way to fix it is to open the table with Advantage Data Architect and reindex or delete the index file (.adi) but I can't do this because the database is used by an accounting software (Sage BOB 50) and if I reindex or delete the index, the software is unable to access the data anymore.
Any ideas?