Warning: odbc_exec(): SQL error: [Microsoft][ODBC dBase Driver] External table is not in the expected format., SQL state S1000 in SQLExecDirect

Question

I am using odbc_connect() to connect php to .dbf files, i tried adding "Microsoft dBase Drive (*.dbf)" to my System DNS. although the connection was successful from my code I cannot run the odbc_exe() to get the data, it show "External table is not in the expected format"

 
   //Storing DSN(Data Source Name created)
  $dsn="myDBFdbDSNConnection";
  $user="";
  $password="";
     
  $conn=odbc_connect($dsn,$user, $password);
  
  if (!$conn)
   {
   echo (die(odbc_error()));
   }
   else
  {
      echo "Connection Successful !";

      $sql="SELECT * FROM table1";
      $rs=odbc_exec($conn,$sql); 
      
  }
  //Resource releasing
  odbc_close($conn);