Advantage Database utility .NET/Delphi

Hi there

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

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

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

REgards ACO


See more: property provider, net fix com, loop net, how to quit, how to get someone to create an app, database skills, v8, utility app, the net connect, delphi\\, ads database, delphi form html, visual basic goal database, form net form, net app server, delphi utility, net course, utility delphi, connect database error, delphi html string, net progress, database connect error, net connect database, utility application, ads network script

About the Employer:
( 27 reviews ) United Kingdom

Project ID: #2719016

1 freelancer is bidding on average $128 for this job


See private message.

$127.5 USD in 7 days
(5 Reviews)