Hello,
We are developing a website primarily 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/timuckun20001207.php3?page=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 records, even though it is definitely running the query. We know it is running the query because if we select large amounts of data it does take a considerable amount of time to return something. The results that are returned are in XML format, and all we would get back is:
<?XML Version 1.0 ?>
<result>
result=Connection Successful!
</result>
</xml>
If anyone might know 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
