RE: [PHP-DB] newbie question: FoxPro Tables and ODBC From: Andrew Hill (ahill <email protected>)
Date: 10/13/00

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 <email protected>]
Sent: Thursday, October 12, 2000 5:20 PM
To: 'php-db <email protected>'
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 <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>