[unixODBC-support] cannot write to Access MDB using unixodbc+mdbtools-odbc-drivers

Nick Gorham nick.gorham at easysoft.com
Thu Mar 27 09:45:00 GMT 2008


Ketjes wrote:

> Hi,
>
> I've got a Microsoft Access-database (database.mdb) with one table 
> (table1) containing one field (field1) of the type "long integer".  
> From within Perl I would like to INSERT a record in this table !
>
> When I perform the Perl-script (see at the bottom), then I get the 
> error "Error at Line : syntax error near INSERT".  I'm pretty sure the 
> SQL-syntax is okay.  A SELECT-query works without ANY problem.
>
> I herby include all relevant configuration-files...
>
> Anyone any advice what might be wrong ?
>
> Many thanks,
>
I would guess this will need to be a question for the mdb tools folks.

-- 
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org




More information about the unixODBC-support mailing list