Does FoxPro have an ODBC module?
I'm in the midst of putting a web front-end on an Access database; we've
put MySQL as the back end to Access using the ODBC connection. Then PHP
can process queries on the MySQL db and the local operators see it as an
Access db.
We first tried PostgreSQL because of its more mature status -- but the
case sensitive text queries were a killer for Access' completion function.
MySQL works like a charm.
On Thu, 28 Mar 2002, John Clarke wrote:
I am thinking about providing real time web access to our coach reservations
system.
The reservations system is on Foxpro2.6 on a SCO Unix 5.0.2 server.
I am considering setting up the web server with FreeBSD, Apache and PHP.
Our reservations system is used by up to 60 operators almost 24 hours per
day via dumb terminals and telnet sessions.
I am interested in any experience anyone may have had with this type of
project and whether there are any major hurdles to overcome or limitations
of the OS's or the Foxpro RDMS.
In particular I am interested in any experience anyone may have had with
reading, writing, and locking Foxpro dbf's using PHP from the web server
while other in house users are doing the same via their terminals and telnet
sessions connected directly to the SCO Unix server. I have had some negative
experiences with locking Foxpro dbf's via NFS and as such I am wary about
it's limitations.
Any comments at all would be greatly appreciated.
Kind regards,
John Clarke
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
