• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
R Uppal
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Jan Cumps
Bartender
Posts: 2588
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Let Me Google That for You

 
R Uppal
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2588
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21107
32
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2588
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't know the product, and it's not free.
But would it help you?
http://www.hxtt.com/dbf.html
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic