How are you going to connect from the fedora box to the Windows Foxpro installation?
Searching the foxpro files via a share will require a big bandwidth, because you will be reading, and transferring, the database file over the network.
The links that I cunningly provided point to solutions that let you use foxpro in client server mode, thus ending with acceptable bandwidt use.
By the way, these links were not intended as an insult.
Joined: Dec 18, 2002
Sorry if i offended you actually I was quite annoyyed that time coz I wasted my couple of days doin googling .
I have a huge database in FoxPro like 200 Tables. I cant afford to switch to anyother database this point.
Cause in that case i need to look for database conversion utilities. Which its self is a huge task.
Yes I my linux box and windows server are on same network no problem in terms of speed.
I am just looking any way to use remote dsn's if that possible through java.
First you have to figure out how to use ODBC on Linux, don't you? And then after that (if it's even possible) you have to figure out how to get a FoxPro ODBC driver which would run on Linux. Or a generic ODBC driver which can run on Linux and connect via an ODBC driver on the Windows box.
But none of this seems related to JDBC (except perhaps that you would need a JDBC-ODBC bridge in your Linux JRE, and I'm not sure whether that exists either). Would you like this thread moved to the forum which deals with Linux instead? It might fit better there.
R Uppal wrote:
Or is there any better way to access free FoxPro tables in jsp in Linux environment.
Suggestions and comments would be appreciated.
One way would be to export your Foxpro Tables as a CSV file. From there you should be able to import the text into your database.... hopefully mysql. Once you've got the data into the database you'll be able to access it both locally and remotely.