You have chosen to sponsor your bid up to a maximum amount of .
I need a small utility that will reindex all tables in a datadictionary.
If I were to use the Advantage Stored procedure sp_PackTables that would work OK if the tables were created in the same instace of AdvantageDB. However, there is an issue if tables were created in another instance of AdvantageDB. You get a 7074 or 5175 error because there is a collation mismatch.
I wanted to write a quick script to loop through all tables in the DB and reindex them. I also note that with the right skills and knowledge, you can set a property of AdsOpenTable=ADS_REINDEX_ON_COLLATION_MISMATCH
But I am not sure how to do this.
I am not sure if this property is only exposed to Delphi tools of it can be exposed in .NET.
I want a small form, Textbox with either OLE provider string or some kind of database enumeration/selection (path to ADD?)
Reindex button with progress indicator, eg: Tablename being reindexed, and of course a cancel/quit button to close the app.
I have written a small script ato do this and it throws a 7074 error as I beleive it is not possible for me to set the correct values
I have reviewed
The goal of this project is to create an application that will fix errors as a result of copying datafiles from one server to another and using the AdvantageDB. It is not possible to connect the two servers via network and use ADS native tools to do this.
Hope someone out there understands this issue.
Currently using ADS v8.1 & 10.1