Hello,

I'm trying to build a web front end (using Java Server Pages) to a legacy FoxPro 2.6 database. I've had limited success using the FoxPro ODBC driver. With the new version of data access components from Microsoft, I am now forced to use the VFP driver. This would be fine, except that when I do a simple query, the ODBC driver cannot find the table (dbf file).

I've read that when going through the JDBC_ODBC bridge, the VFP driver tends to lose the path information that was specified when the driver was created. The solution is to fully qualify the pathname in your SQL. This still doesn't work.

Any ideas? (alternate solutions would also be appreciated)

Thanks,

Andrew Patzer