Solved

Interfacing with FoxPro

Posted on 1997-04-03
3
200 Views
Last Modified: 2013-12-25
Is there an interface (either using CGI, or some other method), that would allow me to access a FoxPro database to store and retrieve data?  There are some specific limitations I have, as listed below:
         1. The database is on a Win32 machine at a remote
      location and would be connected to my location
      (the WWW server) via ISDN.
         2.  The WWW server is a SPARC 10 running Solaris
      version 2.5
      3.  The database is FoxPro v2.6
      4.  The server version is Netscape Enterprise v2.0

Anyone have any suggestions?      
0
Comment
Question by:dada040397
  • 2
3 Comments
 

Author Comment

by:dada040397
Comment Utility
Edited text of question
0
 
LVL 1

Accepted Solution

by:
saji042497 earned 100 total points
Comment Utility
I presume you don't have a web server running running on your WIN32? system(probably a win95). Hense calls for a very complex procedure.

This specific task can be acomplished by some smart implimentation which can go this way.
1) Get a good NFS client for your win32 system.
2) Your WIN32? system can now map volumes from the SUN system.
3) Let your foxpro database reside on the SUN system and your programs run on the WIN32?.
4) Write a CGI program on the Sun system. This program is going to write a small file which is going to have the query in a specific format that you decide.
4) Write a foxpro program that just does a dedicated polls for this file to get updated. Interpret this query and write a file output of this query into the same file system.
5) This is a signal for our CGI program to pick up the result and go about displaying pages.

This solution will have problems if your WIN32? system is going to be online at your remote end. In this case you can use the NFS maped drives only for the flags, and let the database remain on the WIN32? system itself.

Complex Solution isn't it.... :)
0
 

Author Comment

by:dada040397
Comment Utility
I knew there would be some work to make this system work, so I didn't expect it to be simple.  There are still some issues here about mutex, but I think they can be worked around.  Thanks.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I hope you'll find this tutorial useful and interesting. So let's try to extend Tcl with a new package.  For anyone more deeply interested please check out the book "Practical Programming in Tcl and Tk". It's really one of the best written books abo…
It is a general practice to get rid of old user profiles on a computer  in a LAN environment. As I have been working with a company in a LAN environment where users move from one place to some other place at times. This will make many user profil…
Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…
The viewer will learn how to count occurrences of each item in an array.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now