Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

Interfacing with FoxPro

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
dada040397
Asked:
dada040397
  • 2
1 Solution
 
dada040397Author Commented:
Edited text of question
0
 
saji042497Commented:
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
 
dada040397Author Commented:
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now