Connection from PHP to FoxPro

colmtourque

I have searched the web and can't find a working line to connect php to a foxpro database I have tried using ODBC and get errors.
Does anyone have working code.

Here is what I have tried:

$link = odbc_connect ('advassistant', '', '', 0)
or die ("Could not connect");

print ("Connected successfully to foxtest");

$result = odbc_exec($link, "SELECT * FROM SVCCAR");

if (!$result) {
echo odbc_error();
exit;
}

odbc_close ($link);

which returns that no default driver

And odbcless:

$table = 'c:\aa\AAADDR.DBF';

if (!$FileHandler = dbase_open($table,0) ) {
echo "Can't open $table\n";
exit;
} else {
$rowcount = dbase_numrecords ( $FileHandler);// How many records?

for ($i=1; $i <= $rowcount; $i++) { 
      $row = dbase_get_record_with_names($FileHandler,$i);
      echo chop($reg[ID_EMP]) . " : " .
           chop($reg[ID_SUBEMP]) . " : " . 
           chop($reg[NAME_EMP]);
}

}
Which returns the error that dbase_open is not good code.

Thanks in advance.

barand

This is the closest I can find, though I haven't tried it

http://www.php.net/manual/en/ref.dbase.php

colmtourque

Using ADOdb
http://php.weblogs.com/

And the following code:

include('C:\adodb350\adodb.inc.php'); # load code common to ADOdb
$conn = &ADONewConnection('vfp'); # create a connection
$conn->PConnect('advassistant'); # connect to Foxpro, advassistant DSN
$recordSet = &$conn->Execute('select * from aaspell');
if (!$recordSet)
print $conn->ErrorMsg();
else
while (!$recordSet->EOF) {
print $recordSet->fields[0].' '.$recordSet->fields[1].'<BR>';
$recordSet->MoveNext();
}

$recordSet->Close(); # optional
$conn->Close(); # optional

If anyone does know of any code that will do this without the extra product it would be nice. But heck if it works it works.

Thanks

Tracer

What kind of server is the ODBC driver installed on?

I have had wicked permission problems with FairCom ODBC drivers and Windows server (especially when using a mapped or network drive).

Additionally, all Windows ODBC driver should be setup as SYSTEM drivers, and your webserver user will have to have acess permissions to both the ODBC driver, and the drive which the database is located on...