Connecting to Fox Pro DBF Files

Permalink June 04, 2014 at 6:43 AM

Hi there,

I am just wondering if anyone has ever tried connecting to a FoxPro as datasource/database instead of MySQL.

I have been digging the net for days but unable to find a good solution.

Here are some of the approach i did but all failed to connect
1)

include('/Sites/concrete5/concrete/libraries/3rdparty/adodb/adodb.inc.php');
$db = ADONewConnection('vfp');    
$db->PConnect('localhost','DRIVER={Microsoft Visual FoxPro Driver};SOURCETYPE=DBF;SOURCEDB=/Sites/concrete5/tools/fp;EXCLUSIVE=NO;');

include('/Sites/concrete5/concrete/libraries/3rdparty/adodb/adodb.inc.php');
   $db = ADONewConnection('vfp');
   $dsn = 'Provider=vfpoledb;Data Source="/Sites/concrete5/tools/fp;Collating Sequence=general';
$connect = $db->Connect('localhost',$dsn);