Hi,

I have an old software tool that uses a pretty old v2.0  database from dbisam, it works nice but I´m working on a new version of this program and I need a way to get the data from the old database.

Is there a way to do this? Extracting the data to csv i.e. or to any other format that's readable with preferably JAVA?
I tried the ODBC driver but it can't seem to read the v2.0 database:

SQLExecDirect [Elevate Software][DBISAM] DBISAM Engine Error # 12035 The table '
BTWCodes' is not the correct version,HY0,12035
Wrong statement: 'select * from BTWCodes'

So is there a way to do this or is the data from the users lost in the old program?

Thanks in advance!

Hi

I think what you need is a copy of the  DBISAM v2 DBSYS.EXE.  You can use
this to reverse engineer the tables.  You'd need to tinker with the
generated SQL to get it to work in DBISAM v4, no doubt, but that should get
you started.

Cheers

Jeff

--
Jeff Cook
Aspect Systems Ltd
www.aspect.co.nz

<stefnadenhartog> wrote in message
news:7F28A1B9-EEF2-435E-997A-AE085AB0C6A4@news.elevatesoft.com...
> Hi,
>
> I have an old software tool that uses a pretty old v2.0  database from
> dbisam, it works nice but I´m working on a new version of this program and
> I need a way to get the data from the old database.
>
> Is there a way to do this? Extracting the data to csv i.e. or to any other
> format that's readable with preferably JAVA?
> I tried the ODBC driver but it can't seem to read the v2.0 database:
>
> SQLExecDirect [Elevate Software][DBISAM] DBISAM Engine Error # 12035 The
> table '
> BTWCodes' is not the correct version,HY0,12035
> Wrong statement: 'select * from BTWCodes'
>
> So is there a way to do this or is the data from the users lost in the old
> program?
>
> Thanks in advance!
>

<< I have an old software tool that uses a pretty old v2.0  database from
dbisam, it works nice but I´m working on a new version of this program and I
need a way to get the data from the old database.

Is there a way to do this? Extracting the data to csv i.e. or to any other
format that's readable with preferably JAVA? >>

Are you using a later version of DBISAM now, or something different ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com