$conn = new COM("ADODB.Connection");
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$database");
$query = "SELECT * FROM user";
$result = $conn->Execute($query) or die("fail to connection to the
database!");
if ($result->RecordCount()!=-1){
//do something
}
--
Sincerely your;
pei_world ( .::IT::. )
"Pei_world" <pei_world@hotmail.com> wrote in message
20030219020900.95335.qmail@pb1.pair.com">news:20030219020900.95335.qmail@pb1.pair.com...
> when I try to connection to the access file using Microsoft Jet Engine. it
> come up with following error!
> can anyone help me?
>
> $result = $conn->Execute($query) <----error line
> I check the table is exists,and the query should be correct.
>
> ----------------------------------------------------------
> Warning: Invoke() failed: Exception occurred. Source: Microsoft JET
Database
> Engine Description: Syntax error in FROM clause.
> -----------------------------------------------------------------
> thx
> --
> Sincerely your;
>
> pei_world ( .::IT::. )
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
