ID: 32041
Updated by: [EMAIL PROTECTED]
Reported By: mark dot horwell at uhns dot nhs dot uk
-Status: Open
+Status: Bogus
Bug Type: ODBC related
Operating System: Windows XP
PHP Version: 4.3.10
New Comment:
User error -> bogus.
Previous Comments:
------------------------------------------------------------------------
[2005-02-21 11:32:36] mark dot horwell at uhns dot nhs dot uk
Managed to solve the problem, it was an issue with file permissions,
where only set to read only on the database.
Thanks
------------------------------------------------------------------------
[2005-02-21 09:55:42] mark dot horwell at uhns dot nhs dot uk
Description:
------------
When ever i try to delete a record with a MS access database I get the
following error message
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not
delete from specified tables., SQL state S1000 in SQLExecDirect in
C:\Estates Info System\admin\Delete_Site.php on line 13
I know ther no problem with the sql statment, not sure what to do.
I am using PHP, IIS and MS access
Please Help
Reproduce code:
---------------
<?
$connect = odbc_connect ("Information_System","root","");
$query = "DELETE FROM Site WHERE(((Site.[Site Code])='076'))";
odbc_exec($connect, $query);
?>
Expected result:
----------------
Record with key 076 whould be deleted but is not
Actual result:
--------------
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not
delete from specified tables., SQL state S1000 in SQLExecDirect in
C:\Estates Info System\admin\Delete_Site.php on line 13
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=32041&edit=1
