File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes JSP with Visual Foxpro Project Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JSP with Visual Foxpro Project" Watch "JSP with Visual Foxpro Project" New topic

JSP with Visual Foxpro Project

Aravind Prasad
Ranch Hand

Joined: Dec 28, 2005
Posts: 263
Dear Ranchers,
I'm now doing an onsite project in a Logistics Company. They are using a Software which is developed in Visual Foxpro 6 and the database they are using is visual foxpro with the extension dbx.
Due to the increase in the clients, they want to put a track and trace into the webbased solution. They have a domain registered and the Service Providers told to give the JSP and MySQL support. The remote server is Linux machine.

My Questions are

1) How can i synchronize the Foxpro databse to MySQL database

I've found one software in the internet and, it costs $55.

Or can i run the program in the remote machine and put the database in the local server like

Please give me a good idea.. for my career..


Aravind Prasad
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

1) How can i synchronize the Foxpro databse to MySQL database

Not sure what you are trying to do here - by "synchronize" are you looking to replicate the data in the foxpro database in MySQL? Do you want intend to keep using the foxpro database? Or do you just want to know how to do a one-off transfer of the schema?

Sun's driver database lists a bunch of drivers for foxpro.

(I'm suprised your customer is continuing with foxpro, since Microsoft is making noises that they are discontinuing it)
[ March 28, 2007: Message edited by: Paul Sturrock ]

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Aravind Prasad
Ranch Hand

Joined: Dec 28, 2005
Posts: 263
Dear Paul,
Thanks for the reply. I don't know why my client is still continuing with Foxpro. I've found a software in internet which can synchronize the foxpro database with remote mysql database. I've tested. Since it is a trial version, I can only get 10 rows from each table. The software name is FoxPro2MySQL Sync.. I'm planning to buy this Software..


Aravind Prasad
I agree. Here's the link:
subject: JSP with Visual Foxpro Project
Similar Threads
Freelance Developer
You are Right-A Beginner
passed SCJP2 with 83%..........
Accessing Foxpro table using servlerts/jsp