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?      
dada040397Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Scripting Languages

From novice to tech pro — start learning today.