problem in PHP with ADODB connection, Microsoft JET Database
| From: | pei_world | Date: | Wed, 19 Feb 2003 19:57:26 +0000 |
| Subject: | problem in PHP with ADODB connection, Microsoft JET Database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-136241@lists.php.net to get a copy of this message | ||
when I try to connection to the access file using Microsoft Jet Engine. it
come up with following error!
can anyone help me?
$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
}
----------------------------------------------------------
Warning: Invoke() failed: Exception occurred. Source: Microsoft JET Database
Engine Description: Syntax error in FROM clause.
-----------------------------------------------------------------
thx
--
Sincerely your;
pei_world ( .::IT::. )