Page 1 of 1

Working with FoxPro database

Posted: Tue Aug 15, 2006 10:53 am
by Luke
What do I need to work with a database created by foxpro? "DBF" format. I am googling it as well, I just thought I'd ask here too. From what I've read, the server needs an odbc driver? Is that right?

Posted: Tue Aug 15, 2006 8:14 pm
by RobertGonzalez
Yep. I think that the FoxPro issue has been spoken about before here, but I think there are various foxpro viewers that will let you grab the data in the FoxPro database and export it to another format. Are you committed to FoxPro?

Posted: Tue Aug 15, 2006 9:11 pm
by Luke
Foxpro files are generated by a 3rd party application. I can not change the application, so I have to find a way to either export xml files of the data nightly, or I have to find a way to access the files directly with php. All I need to do are selects, no modifying at all.

Posted: Tue Aug 15, 2006 9:28 pm
by RobertGonzalez
Is there a client api available for it? Or will ODBC or PDO take care of it? I am throwing out the questions because I don't know. I have never had to work with Foxpro through PHP.

Posted: Tue Aug 15, 2006 9:37 pm
by Luke
I've never worked with anything but mysql to be honest. Image