Advantage Database utility .NET/Delphi

This project received 1 bids from talented freelancers with an average bid price of $128 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$100 - $150 USD
Total Bids
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online