Hi,
I am trying to retrieve some data out of a couple of tables from an old Progress 10.0B database which was then fixed to work in Progress 10.2B (of which I have the Evaluation copy at present). I have managed to get at 90% of the data but there are 14 tables which appear to elude me. I am using the Progress 10.2B ODBC driver in Windows Server 2003 Enterprise Edition.
I have tried to download the data in both R and DTS Wizard (SQL Server) the first of which crashes when I try to access the data, the second just throws numerous messages and refuses to get any data.
Here is what I have done so far:
6 tables, I cannot read any data from at all. I can see the structure using Data Administration but cannot dump the data to file as this is not allowed in the Evaluation copy (hence my use of ODBC to pull the data out).
8 tables I cannot read all the data all at once but I can read some of the initial records, a different number per table.
On all 14 tables I can get the number of records in the table.
Both of these seem to me like the tables are corrupted somehow.
Running proutil dump on them I can download binary dumps of most of the tables which is a bit strange. Although on 3 I get messages such as
"Could not find record. Recid 11297795, error number 8, return -1. (12011)"
These 3 tables were repairable running the index (proutil [db] -C fixidx). But the rest are still inaccessible using ODBC.
Can someone tell me if there are any table fixing routines which could fix these issues?
Thanks
Tom
I am trying to retrieve some data out of a couple of tables from an old Progress 10.0B database which was then fixed to work in Progress 10.2B (of which I have the Evaluation copy at present). I have managed to get at 90% of the data but there are 14 tables which appear to elude me. I am using the Progress 10.2B ODBC driver in Windows Server 2003 Enterprise Edition.
I have tried to download the data in both R and DTS Wizard (SQL Server) the first of which crashes when I try to access the data, the second just throws numerous messages and refuses to get any data.
Here is what I have done so far:
6 tables, I cannot read any data from at all. I can see the structure using Data Administration but cannot dump the data to file as this is not allowed in the Evaluation copy (hence my use of ODBC to pull the data out).
8 tables I cannot read all the data all at once but I can read some of the initial records, a different number per table.
On all 14 tables I can get the number of records in the table.
Both of these seem to me like the tables are corrupted somehow.
Running proutil dump on them I can download binary dumps of most of the tables which is a bit strange. Although on 3 I get messages such as
"Could not find record. Recid 11297795, error number 8, return -1. (12011)"
These 3 tables were repairable running the index (proutil [db] -C fixidx). But the rest are still inaccessible using ODBC.
Can someone tell me if there are any table fixing routines which could fix these issues?
Thanks
Tom