Reading FoxPro 2.6 Data Using Java

Question

I am trying to read a FoxPro 2.6 database using java to retrieve data from an older FoxPro-based application to better format the output. I tried using JavaDBF and xBaseJ without success. Is there a general connection method that will allow me to get this information in my Java application?

Answer 1

It has been a long time since I connected to the FoxPro database from a Java application, but this is what I remember when I was supposed to do:

• I installed the FoxPro ODBC driver .
• Install as Windows System DSN for the FoxPro ODBC driver.
• Then, the JDBC-ODBC bridge was used to connect to the FoxPro database.

Answer 2

You can try JDBF: https://github.com/iryndin/jdbf

It works without ODBC, with the DbfRecord class, you can read a DBF file record by record.

When I created it, it was my intention to be able to read / write DBF on Linux boxes, since you do not have ODBC drivers in Linux.

Recently, support for MEMO fields was added at the request of the JDBF user. You can send your own requests, and I will consider them for implementation.