Accessing a visual foxpro database from a java web app

I am wondering if anyone has had luck accessing a VFP database via the web using Java?  We are currently working on a prototype and are using the free JDBC-ODBC driver which seems to work fine except on some of my more complex queries.  For some reason it will not execute imbedded select statements.  These run fine in the actual foxpro development system, so is it just that I need a better driver/bridge?
Who is Participating?
CEHJConnect With a Mentor Commented:
>>so is it just that I need a better driver/bridge?

Yes probably
gatorvipConnect With a Mentor Commented:
Check the documentation for the driver that you use now, if it doesn't allow "complicated" queries it should probably be documented
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.