Skip to main content
tclaremont
Inspiring
June 17, 2008
Question

Connecting to a FoxPro Database

  • June 17, 2008
  • 2 replies
  • 602 views
I have been connecting to a FoxPro database for years now with the ODBC Connector. It works OK, but would like to know if there is a JDBC connector available these days. My searches have uncovered ODBC-JDBC Bridges, but I am not sure if that buys me anything.

What is the current standard for connecting CF 7.02 to a FoxPro data directory?

This topic has been closed for replies.

2 replies

Inspiring
June 18, 2008
recently i had the problem with mx8.
to connect to foxpro tables on other machines on the network.
All my efforts with odbc failed, so i wonder how you managed it in the past. Are your dbf-files on the same machine?
in the thread

http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=6&threadid=1214129&highlight_key=y&keyword1=foxpro
the solution is mentioned.
A product HXTT DBF v4.0 from www.hxtt.com/dbf.html connects to the dbf - files. price : 260$
June 18, 2008
I know that FoxPro used to be Datasource list back in CF5, but recollecting on a case that I had, we had to create an ODBC-JDBC Bridge using the Jadozoom Drivers. It's included on the MX (6-7) package. So to answer your question, there is no standard for connecting MX to FoxPro

This is an old technote that deals with an old Access DB, but the solution could be applied to FoxPro - http://kb.adobe.com/selfservice/viewContent.do?externalId=2d2a7a19

HTH