> From: "Hai Trieu, Nguyen" <haitrieu@[...].com>
> To: "Ilya Sterin" <ideas_pc@[...].com>, <dbi-users@[...].org>
> Subject: Re: Couldn't write to Ms Access  Database by DBD:ODBC
> Date: Thu, 19 Oct 2000 09:09:21 +0700
> 
> This is a single table, you know this DB was for testing so i just made a 
> temp DB, so of course it has ony one table.

Can you read from the table ( ie select ) . My guess is no, which makes this 
a permissions problem.

>    Hi all!
>    Can anyone tell me how to solve this problem:
>    I tried updating the database in Ms Access format (.mdb) by using 
> DBD::ODBC
>    (on IIS/ win2000). But i could only read (by SELECT) the data, could not
>    write (by INSERT INTO, or UPDATE).
>    When I trace DBI::errstr, it was :
>    "[Microsoft][ODBC Microsoft Access Driver] Operation must use an 
> updateable
>    query. (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) "
> 
>    I'm sure every read/write security was correctly set, some of my script 
> is:
> 
>    use DBI;
>    $dbh = DBI->connect("DBI:ODBC:Save", "admin","pass");
>    $sql = "INSERT INTO Data (ID, Name) VALUES (3, 'Peter' )";
>    $dbh->do($sql) or print "error = $DBI::errstr";
>    $dbh->disconnect;
> 
>    # Save is the DSN
> 
>    I tried to replace DO command by PREPARE and EXECUTE but it generated 
> the
>    same error.
>    I'll preciate any suggestion.
>    Thanks.
> 
> 
>    
> ------------------------------------------------------------------------------
>    DBI HOME PAGE AND ARCHIVES: 
> http://www.symbolstone.org/technology/perl/DBI/
>    To unsubscribe from this list, please visit:
>    http://www.isc.org/dbi-lists.html
>    If you are without web access, or if you are having trouble with the web
>    page,
>    please send mail to dbi-users-request@[...].org with the subject line of:
>    'unsubscribe'.
>    
> ------------------------------------------------------------------------------
> 
> 
>    ______________________________________________
>    FREE Personalized Email at Mail.com
>    Sign up at http://www.mail.com/?sr=signup
> 
> 
> 
>    
> ------------------------------------------------------------------------------
>    DBI HOME PAGE AND ARCHIVES: 
> http://www.symbolstone.org/technology/perl/DBI/
>    To unsubscribe from this list, please visit:
>    http://www.isc.org/dbi-lists.html
>    If you are without web access, or if you are having trouble with the web
>    page,
>    please send mail to dbi-users-request@[...].org with the subject line of:
>    'unsubscribe'.
>    
> ------------------------------------------------------------------------------
> 
> 
>    ______________________________________________
>    FREE Personalized Email at Mail.com
>    Sign up at http://www.mail.com/?sr=signup
> 
> 
>    
> ------------------------------------------------------------------------------
>    DBI HOME PAGE AND ARCHIVES: 
> http://www.symbolstone.org/technology/perl/DBI/
>    To unsubscribe from this list, please visit: 
> http://www.isc.org/dbi-lists.html
>    If you are without web access, or if you are having trouble with the web 
> page,
>    please send mail to dbi-users-request@[...].org with the subject line of:
>    'unsubscribe'.
>    
> ------------------------------------------------------------------------------
> 
> 
> 
> ------------------------------------------------------------------------------
> DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/
> To unsubscribe from this list, please visit: 
> http://www.isc.org/dbi-lists.html
> If you are without web access, or if you are having trouble with the web 
> page,
> please send mail to dbi-users-request@[...].org with the subject line of:
> 'unsubscribe'.
> ------------------------------------------------------------------------------
> 

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.



------------------------------------------------------------------------------
DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/
To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the web page, 
please send mail to dbi-users-request@[...].org with the subject line of:
'unsubscribe'.
------------------------------------------------------------------------------