A few years later, I also became a victim to connect with a FoxPro database.
I’ve meanwhile found a driver combination that’s a bit stable, using the RMI connection to a locally installed JDBC driver from sesamesoftware (the site you go to when you follow the old link to csv-jdbc).
However, I still have problems with the character encoding. The text in the console should be “lumière”, but it ends up with a strange S (same as in the interface). So it appears that the è is encoded as 0x8a, which would point to IBM437 being used as I found on stackoverflow.
The driver offers the ability to alter the encoding, however, it appears that the IBM437 encoding is no standard encoding. What would be the best option to display the accents correctly?
