Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC dBase Driver] External table is not in the expected format., SQL state S1000 in SQLExecDirect in C:\AppServ\www\dBase\index.php on line 5
[Microsoft][ODBC dBase Driver] External table is not in the expected format.
อันไฟล์ connect (incODBC.php)
Code (PHP)
<?php
$DNS = "ODBCdBase";
$USER = "";
$PASS = "";
$strConn = odbc_connect("$DNS","$USER","$PASS") or die (odbc_error());
?>
อันนี้ไฟล์ที่ Error ครับ
Code (PHP)
<?php
require_once('include/incODBC.php');
$strsql= 'SELECT * FROM dBase.dbf';
$query = odbc_exec($strConn,$strsql) or die (odbc_errormsg());
while($row = odbc_fetch_array($query))
{
echo 'Name: '.$row['NAME'].'';
echo 'Lastname: '.$row['LASTNAME'].'';
echo '<hr />';
}
odbc_close($odbc);
?>
Load balance : Server 00
