Hello,
We are developing a website in PHP and we need to retrieve just a few records from a FoxPro Database that is used by a software program called Fabritrak, made by a company called Metalsoft. I have spent many hours trying to find a solution for this and ran across something called ODBC Socket Server from a tutorial located here http://www.phpbuilder.com/columns/ti...2&print_mode=1
We easily installed the ODBC Socket Server on a WINNT server and we were definitely successful in making a connection to the database from our Linux web server. The problem is, it would return no actual records, even though it is definitely running the query. We know it is running the query because if we select a large amount of data it takes a considerable amount of time to return something. The results that are returned are in XML format, and all we get back is:
----------------------------------------------------------
<?XML Version 1.0 ?>
<result>
result=Connection Successful!
</result>
</xml>
----------------------------------------------------------

If anyone might no why we are not getting the actual records back, or know of another reasonably priced software program that would allow us to get data from a remote FoxPro Database using Linux and PHP it would be very much appreciated.
Thank You,
Matt

The solutiion is to use ODBTP instead. Details at http://odbtp.sourceforge.net. It is much better and faster than ODBC Socket Server.