Iseries and Access

[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

 

[Ed]

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.

 

[Nigelbennett]

I have done that the error I get is sql7008, not valid
for operation

thanks

Nigel

 

[Rick Brandt]

I have done that the error I get is sql7008, not valid
for operation

Do the tables have primary keys defined?

 

[Nigel Bennett]

We had to turn on journalling on the tables we were
working with and then we were able to add records

Thanks to all