Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Interfacing with FoxPro

Posted on 1997-04-03
3
Medium Priority
?
211 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 200 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This tutorial will discuss fancy secure registration forms, with AJAX technology support. In this article I assume you already know HTML and some JS. I will write the code using WhizBase Server Pages, so you need to know some basics in WBSP (you mig…
Making a simple AJAX shopping cart Couple years ago I made my first shopping cart, I used iframe and JavaScript, it was very good at that time, there were no sessions or AJAX, I used cookies on clients machine. Today we have more advanced techno…
Learn the basics of modules and packages in Python. Every Python file is a module, ending in the suffix: .py: Modules are a collection of functions and variables.: Packages are a collection of modules.: Module functions and variables are accessed us…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

730 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