RE: [PHP-DB] newbie question: FoxPro Tables and ODBC

Hi Lee, To use the Foxpro driver on the Windows box, you will need to get to it somehow first. iODBC is not a driver, but a driver manager, so you still need some driver on the Linux box so you can cross machine boundries. One solution is Openlink's Multi-Tier driver; setup with your linux as client and your windows as server. Create your DSN on the Windows box with the Foxpro driver, called 'foo' for this example. Create you DSN in the odbc.ini on the linux box, normally except for: ServiceType = odbc Host = windows box Database = foo This will effectively piggyback the comm layers. BTW - you don't need to specify a database when installing on Windows, but go into the database agent selection (once you are in the web-installer) and ensure you have selected the ODBC agent (odbc_sv). Best regards, Andrew ---------------------------------------------------- Andrew Hill Manager Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider -----Original Message----- From: Lee Pope [mailto:lee_pope@inforum.net] Sent: Thursday, October 12, 2000 5:20 PM To: 'php-db@lists.php.net' Subject: [PHP-DB] newbie question: FoxPro Tables and ODBC Hi y'all-- I'm new to this list, and after a little searching, still haven't come up with an answer to this question. I'm running Apache 1.3, PHP 4 and iODBC on a linux server, but need to get information from some FoxPro 2.6 Tables residing on a Windoz box next door. When I use odbctest, I can query the FoxPro tables just fine. From PHP, I an connect to the tables, but when I try to use any of the following: odbc_prepare(); odbc_execute(); odbc_exec(); odbc_do(); I get errors from the windows driver, and no data is returned. Any ideas? Thanks, lee -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net