On Dec 13, 5:47 pm, "SilentWing" <u39867@[EMAIL PROTECTED]
> wrote:
> Hi Folks:Back in 1987 (yes 20 years ago), one of my employment ancestors
> wrote a DB in Progress 4.2a.I have been given the task to figure out a
way to
> extract the data (preferably into excel or Access) with eventual
im****ting
> into MySQL. Any idea where I can find an ODBC connector for 4.2a (if
one
> exists), or how else I can extract the data - text files would be
acceptible.
> The size is tiny. The .db file is 105kb and the .bi file is 256kb.
> Any help would be greatly appreciated.
>
> --
> Regards,
> SilentWing
>
> If it is to be, it's up to me!
There is no ODBC connector for 4.2a.
You'll need to dump the data into a flat file through the data
dictionary and then reload it into a more modern version of progress
(aka 10.1b.) From there you can make an ODBC connection.
I have code that ex****ts schema and data from Progress into MySQL and
PostgreSQL via SQL statements, but I can guarantee you it won't work
on anything short of 9.1e.
If you want the code, send me email at scottauge at gmail dot com -
it's libre open source, I'll just send ya a zip file.
If you don't have a budget for a newer version of Progress, ya get to
make some hours dumping the data into a format the data dictionary can
handle and re-massaging it into what you need.


|