Solved

Interfacing with FoxPro

Posted on 1997-04-03
3
208 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

by:dada040397
ID: 1827880
Edited text of question
0
 
LVL 1

Accepted Solution

by:
saji042497 earned 100 total points
ID: 1827881
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
ID: 1827882
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

Is Your Team Achieving Their Full Potential?

74% of employees feel they are not achieving their full potential. With Linux Academy, not only will you strengthen your team's core competencies but also their knowledge of of the newest IT topics.

With new material every week, we'll make sure that you stay ahead of the game.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you get a (Blue Screen of Death), your system writes a small file called a minidump. Your first step is to make certain your computer is setup to record memory dumps. Right click My Computer, choose properties. Click on the advanced tab, an…
Batch, VBS, and scripts in general are incredibly useful for repetitive tasks.  Some tasks can take a while to complete and it can be annoying to check back only to discover that your script finished 5 minutes ago.  Some scripts may complete nearly …
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

734 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