We have a need to examine data from an app that is using DBISAM version 2.00 tables.  Is there an ODBC driver
available to access these tables?  The downloadable trial ODBC driver reports that the tables are not the "correct
version" (DBISAM Engine Error #12035).  If there is a trial version of this driver, please advise and send along if
possible.  If not, what would be the cost to purchase?

Thanks in advance,
Fred Stevens,
California Department of Food and Agriculture
Animal Health Branch

Hi Fred,

There is a driver available in the binaries newgroup (posted 29/04/2005)
Just do a search for ODBC and you should find it.

Chris Holland


Fred Stevens wrote:
> We have a need to examine data from an app that is using DBISAM version 2.00 tables.  Is there an ODBC driver
> available to access these tables?  The downloadable trial ODBC driver reports that the tables are not the "correct
> version" (DBISAM Engine Error #12035).  If there is a trial version of this driver, please advise and send along if
> possible.  If not, what would be the cost to purchase?
>
> Thanks in advance,
> Fred Stevens,
> California Department of Food and Agriculture
> Animal Health Branch
>

Thanks Chris!
I downloaded, installed and created a DSN with this driver then tried to access the data  with both my main dev
environment (Visual FoxPro) and Excel 2000 and got fatal windows errors in both with Exception
Code=0EEDFADE.  The WinSQL tool was able to partially open the table via ODBC and display the data, but the
column headers were corrupted.  Just FYI, I was able to convert or "upgrade" the version 2 table to version 3
using the DBSYS utility in the version 3 accessories download (also version 4) and access it via ODBC with no
problems, but this won't be a good solution ultimately, unless DBSYS could do the conversion unattended with a
command line option (?)...

Any ideas?  I can supply the DBISAM version 2 data table if needed - it is a small sample data set.
Thanks again,
Fred Stevens


Chris Holland <mail@chrisholland.me.uk> wrote:

Hi Fred,

There is a driver available in the binaries newgroup (posted 29/04/2005)
Just do a search for ODBC and you should find it.

Chris Holland


Fred Stevens wrote:
> We have a need to examine data from an app that is using DBISAM version 2.00 tables.  Is there an ODBC
driver
> available to access these tables?  The downloadable trial ODBC driver reports that the tables are not
the "correct
> version" (DBISAM Engine Error #12035).  If there is a trial version of this driver, please advise and send along
if
> possible.  If not, what would be the cost to purchase?
>
> Thanks in advance,
> Fred Stevens,
> California Department of Food and Agriculture
> Animal Health Branch
>

Fred,

<< and access it via ODBC with no problems, but this won't be a good
solution ultimately, unless DBSYS could do the conversion unattended with a
command line option (?)... >>

You can upgrade tables using straight SQL using the version 4 ODBC driver
(UPGRADE TABLE statement).  That should allow you to create a command-line
program using any tool that can use ODBC for upgrading the tables as needed
for access via the version 4 ODBC driver.

--
Tim Young
Elevate Software
www.elevatesoft.com