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
