Hi everyone,
In advance I wanted to thank you for your time in replying to my post.
My company is trying to integrate their current foxpro databases with PHP. I am using ADODB on the PHP server and connecting using an Visual Foxpro ODBC driver. We are running into an issue where foxpro doesn't allow us to update to memo fields over 255 characters. I ran across a link , but since I am working in PHP I'm not sure if it applies to what I'm doing.
Any suggestions would be greatly appreciated.
Here is the error I am recieving:
37000: [Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword.
Here is my php code:
<?php
include('c:\adodb\adodb.inc.php');
$driver = "vfp";
$server = "foxpro";
$user = "*******";
$password = "*******";
$database = "c:\\inetsrv\\foxwebdll\\ho\\data\\";
$conn = ADONewConnection($driver); # eg. 'mysql' or 'oci8'
$conn->debug = true;
$conn->Connect($server, $user, $password, $database);
$blah = "Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Cras fringilla magna sit amet ante. Quisq Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Cras fringilla magna sit amet ante. Quisq Lorem ipsum dolor sit amet, consectetuer adipiscing eLorem ipsum dolor sit amet, consectetuer adipiscing elit. Cras fringilla magna sit amet ante. Quisq Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Cras fringilla magna sit amet ante. Quisq Lorem ipsum dolor sit amet, consectetuer adipiscing e";
$conn->UpdateBlob('arjobs92', 'ho_notes', $blah, 'job_no=\'2983973\'');
$recordSet = $conn->Execute("SELECT ho_notes,rep_no from arjobs92 where job_no = '2981332'");
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
?>
