Error Exporting to AS400 library

[Guest]

ODBC--call Failed.

[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL7008 -
CLM2005 in P$BOCONNOR not valid for operation. (#-7008)


ODBC – call failed. (Error 3146)
Using an ODBC connection, you tried to perform an operation on data in an
ODBC data source. This error may occur when the ODBC data source is on a
network drive and you are not connected to the network. Make sure the network
is available, and then try the operation again.

I know I can access library because I have a linked file in that library
that I can view.

Any help would be appreciated

 

[Rick Brandt]

ODBC--call Failed.

[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL7008
- CLM2005 in P$BOCONNOR not valid for operation. (#-7008)

Not valid for operation often means that you are attempting an update using
a transaction and the table is not journaled. Either change the setting in
ODBC to Commit immediate (*NONE) or turn on journaling for the table.

I have also seen this when using version 10.00.00.00 of the IBM ODBC driver
even when the commitment control settings are correct and/or the table is
journaled. Updating to the latest version has always fixed that (so far).