Working with FoxPro database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Working with FoxPro database

Post 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?
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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?
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Post 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.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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.
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Post by Luke »

I've never worked with anything but mysql to be honest. Image
Post Reply