>>While I was installing it at work I noticed a dbf driver for VFP that should work in it. Here it is: http://members.tripod.com/~ZYH/jdbc.html
>
>Would you mind dropping me an e-mail at my personal address (dmstowell@ameritech.net) letting me know how experimentation with VFP goes, as that is currently my bread-and-butter language? Additionally, any links to get the thing going would help. Thanks.


Success, David.
The keys to success were two:
Using a correct URL string, and making sure all tables, extensions and column names were UPPER case, including CDX files, etc...
The correct URL string for the Linux version is:
jdbc:DBF:////full_path_to_your_dbf_files_directory i.e.:
jdbc:DBF:////home/jerry/dbf/dbffiles


Here was the help Zhao Yonghong sent me:
******************************************
Dear Jerry Kreps,

Please use "jdbc:dbf:////home/jerry/dbf/dbffiles".

DBF URL format:
         Direct Access:
                 jdbc:DBF:[//]/[DatabasePath]
                         For example: "jdbc:DBF:/." "jdbc:DBF:/D:/ZYH"
                 For unix or linux:
                         jdbc:DBF:///[DatabasePath]
                                 For example: "jdbc:DBF:////usr/data"
         Access by DBF Server: Skip it if you don't use RMI or JINI.
                 jdbc:DBF:[//][host][:port]/[DatabasePath]
                         Default host:localhost port:2129 DatabasePath:
                         For example: "jdbc:DBF://domain.com:1099/D:/ZYH" if one DBFServer
is run on the 1099 port of domain.com

Any problem? Please let me know.

With best regards,

Zhao Yonghong

Jerry Kreps wrote:

> Using your DBF JDBC 2.0 Driver Beta5 I have been able to connect via jdbc to VFP free tables on Win2K, but I cannot get a connection on my SuSE 7.3.
> My connection string is:
> jdbc:dbf:jerrykreps.athome/home/jerry/dbf/dbffiles
> and it give an error msg saying 'connection refused'
************************************************************************
Have fun!
JLK