Iseries and Access

  • Thread starter Thread starter Nigel Bennett
  • Start date Start date
N

Nigel Bennett

When connecting to the iseries using the iseries access
odbc driver, i am able to link tables but not able to
modify them, in the odbc configuration read\write is
checked. anyone have a reason why I would not be able to
write to a table on the iseries (Tables properties are
*all)

thanks
 
In the ODBC Server Mode tab, Advanced, change the commit mode to Read
Uncommitted.

You will probably also want to check the box on the Translation tab to
convert binary data to text.
 
We had to turn on journalling on the tables we were
working with and then we were able to add records

Thanks to all
 
Back
Top