Hi,
How to create and resolve below error while trying to update any file (which is there on IBM i(AS/400) ) USING MS Access:-
"
"ODBC- update on a linked table Libraryname_ Filename' failed.
[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL7008- Filename in
libraryname not valid operation.(#-7008) "
For the file which is not journaled and even journaled, I tried all the
below Commit mode options in Advance server options still could not
generate this error :-
Commit mode:
Commit immediate(*None)
Read uncommited (*CHG)
Read commited(*CS)
Repeatable read (*ALL)
Serializable (*RR)
***************************
also tried by changing various Connection types available under IBM i
Access Windows ODBC Driver Connect:
1) Use ODBC access mode
2) Use ODBC access mode, Call allowed
3) Limit to Read/Call(Select and Call statements allowed)
4) Limit to Read-Only (Select statements only)
But could not generate that error(SQL7008) so someone could please help to understand how to create this error and then resolve this error with proper steps and examples.
Thanks.
How to create and resolve below error while trying to update any file (which is there on IBM i(AS/400) ) USING MS Access:-
"
"ODBC- update on a linked table Libraryname_ Filename' failed.
[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL7008- Filename in
libraryname not valid operation.(#-7008) "
For the file which is not journaled and even journaled, I tried all the
below Commit mode options in Advance server options still could not
generate this error :-
Commit mode:
Commit immediate(*None)
Read uncommited (*CHG)
Read commited(*CS)
Repeatable read (*ALL)
Serializable (*RR)
***************************
also tried by changing various Connection types available under IBM i
Access Windows ODBC Driver Connect:
1) Use ODBC access mode
2) Use ODBC access mode, Call allowed
3) Limit to Read/Call(Select and Call statements allowed)
4) Limit to Read-Only (Select statements only)
But could not generate that error(SQL7008) so someone could please help to understand how to create this error and then resolve this error with proper steps and examples.
Thanks.