Everything installed fine without an issue. I setup the ODBC and ran a test connection and everything was fine.
I tested it out, using my script below, and it wanted a .CDX file (I only used .dbf for the adodb system. I am hoping this will be much faster than that). I then downloaded the entire foxpro folder and updated my content with this fresh dump. I had to reboot my computer due to a non-related issue and now when I click test, I get this error:
Code: Select all
Access violation at address 000007FEF2C6A056 in module 'odbc32.dll'. Read of address 000000000000000000
Code: Select all
Warning: odbc_connect(): SQL error: [Devart][ODBC][xBase]Error: FileStream.Size 0, readed 0, SQL state 08001 in SQLConnect in M:\__LOCATION__\public_html\_cron\test.php on line 6
I have tested using:
Code: Select all
DBF Format=FoxPro2;
Code: Select all
DBF Format=VisualFoxPro
My script:
Code: Select all
$dsn = 'DRIVER={Devart ODBC Driver for xBase};Database=M:\__LOCATION__\public_html\_cache\VP10\PRAXIS\;DBF Format=VisualFoxPro;Code Page=UnitedStatesOEM;Connect Mode=Exlusive';
$conn = odbc_connect($dsn, '', '');
if (false === $conn) {
die('ODBC Connection Failed');
}
$sql = "SELECT custno, company FROM arcust01 WHERE company <> '' ORDER BY custno;";
$rs=odbc_exec($conn,$sql);
while (odbc_fetch_row($rs)) {
$custno=odbc_result($rs,"custno");
$company=odbc_result($rs,"company");
echo '<ul>';
echo '<li>';
echo "<strong>{$custno}: </strong>";
echo $company;
echo '</li>';
echo '</ul>';
}
exit();
Code: Select all
$conn = odbc_connect('Praxis', '', '');
Code: Select all
Warning: odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application, SQL state IM014 in SQLConnect in M:\__LOCATION__\public_html\_cron\test.php on line 50
ODBC Connection Failed