CODEWITHSUNDEEP
c#.netindexingcollationadvantage-database-server
Azzedine Hassaini
Azzedine Hassaini

Reputation: 331

Advantage Database Error 5175

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?

Upvotes: 3

Views: 2356

Answers (1)

Jens Mühlenhoff
Jens Mühlenhoff

Reputation: 14883

The collation your connection will use depends on the way you are connecting to the server. (See also Advantage Database Index Collation Sequence).

In order to avoid the 5175 error you should use the same connection method that the accounting software uses.

If it uses ALS you can copy the adslocal.cfg config file over to your application. If it uses ADS you should make sure that you connect to the same database server that the accounting software does.

Upvotes: 4

Related Questions