aspose file tools*
The moose likes JDBC and the fly likes JDBC:ODBC, Remote DSN and FoxPro (I am confused...) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC:ODBC, Remote DSN and FoxPro (I am confused...) " Watch "JDBC:ODBC, Remote DSN and FoxPro (I am confused...) " New topic
Author

JDBC:ODBC, Remote DSN and FoxPro (I am confused...)

R Uppal
Greenhorn

Joined: Dec 18, 2002
Posts: 16
I am just in a design phase. I want to access dbase FoxPro free tables from jsp's pages.

I found an application in my library which can serve the purpose properly after minor changes.
But it’s been developed considering windows environment (VFP ODBC DSN connection).

Now problem is currently I have only Linux server with apache tomcat 5 on it.

I tried everything on my fedora X64 server to make a dsn connection to access those FoxPro free tables but no luck so far .

Now I started thinking about remote dsn connections from fedora 64 bit.

I have another windows 2003 server. I don’t want to configure apache tomcat on this one due to some security concerns and nature of application.

I can keep tables on it and install VFP ODBC so I access them remotely.
Question is, is it possible to make a remote dsn connection from Linux to windows .

Or is there any better way to access free FoxPro tables in jsp in Linux environment.

Suggestions and comments would be appreciated.

@Uppal

Sun Certified Java Programmer
PRINCE2 Practitioner
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2516
    
  10

Let Me Google That for You


OCUP UML fundamental and ITIL foundation
youtube channel
R Uppal
Greenhorn

Joined: Dec 18, 2002
Posts: 16
Thanks for Google link a 5 yr old can tell that.

Probably you completly missed my point. I am not developing client server foxpro.


I am trying to find a way to make a remote dsn connection with foxpro free tables from jsp pages on my linux server.
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2516
    
  10

I am not developing client server foxpro
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.
R Uppal
Greenhorn

Joined: Dec 18, 2002
Posts: 16
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.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18989
    
    8

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.
Don Weaver
Greenhorn

Joined: Mar 18, 2009
Posts: 1
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.

@Uppal



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.





Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2516
    
  10

I don't know the product, and it's not free.
But would it help you?
http://www.hxtt.com/dbf.html
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC:ODBC, Remote DSN and FoxPro (I am confused...)