index files are deleted.

[mathmax]

Hello

Sorry for posting here in English, but I'm french and I didn't find any english forum for ADS. Any url to a good english forum will be welcome.

I have a problem when I index a file with ADS. After the "index on" command, the .ntx file is created but it's removed as soon as I close the database or exit the program. Does anybody knows why ?

Thank you in advance for any help.

Regards,

mathmax

[PM Heiko]

Hello

Sorry for posting here in English, but I'm french and I didn't find any english forum for ADS. Any url to a good english forum will be welcome.

I have a problem when I index a file with ADS. After the "index on" command, the .ntx file is created but it's removed as soon as I close the database or exit the program. Does anybody knows why ?

Thank you in advance for any help.

Regards,

mathmax

What if you use the Data Architekt tool to create indexes?

Heiko

[Joachim Dürr]

Sorry for posting here in English, but I'm french and I didn't find any english forum for ADS. Any url to a good english forum will be welcome.

news:devzone.advantagedatabase.com

I have a problem when I index a file with ADS. After the "index on" command, the .ntx file is created but it's removed as soon as I close the database or exit the program. Does anybody knows why ?

Which IDE do you use? Do you connect to a data dictionary? If so: Do you login as administrative user?

[mathmax]

Thank you for your answers.

I use a data dictionary without password.

Here is the code I use to connect:

RddRegister( "ADS", 1 )      // ADS for xHarbour
RddSetDefault( "ADS" )       // ADS for xHarbour
AdsSetServerType(1)
AdsSetFileType(1)  // ntx
AdsConnect60("D:\q\OrkosDD.add")

I think I have to add the index files via the data architect. But if so, I get an error (5054 AE_PERMISSION_DENIED) as soon as I try to reindex. Do you know why ?

Regards,

mathmax

[Joachim Dürr]

I use a data dictionary without password.

That's the issue: you need to login as ADSSYS or any other user that belongs to the DB:ADMIN group.
f'up in the Advantage Newsgroups (I've seen the xpost there)

[mathmax]

ok now I connect using adssys and a password but I get a new error when I try to reindex:
Error ADSNTX/5089 Create error: adrcocl
The operation is not valid for the autoopen index.

What's the problem?

[mathmax]

Could anyone help me with this problem ?