I am trying to retrieve data from Peachtree for use in a custom JAVA application. I have downloaded and installed an ODBC driver that works with Btrieve, connected to it through Suns JDBC-ODBC bridge, and can see the tables (I'm using Squirrel to test this). However, whenever I try to see any of the data, I crash the program.
I'm still pretty green when it comes to this database, so I have some questions.
Can I use basic SQL syntax to reference data out of Peachtree's Btrieve database?
Does anyone know of a client that would allow me to browse though this data?
Is there a working JDBC driver for Btrieve v6.5 that I could use instead of having to use a bridge (I found a Pervasive one on thier site, but you have to have a version of Pervasive installed to extract it for some reason)?
Thanks in advance for the help.