Unanswered: Provider returned message: SQL7008 - not valid for operation
I'm not sure if this is a DB2 or SQL Server issue, however here it is...
I have a sql server 2000 database and have linked a DB2 database ( which is on an AS400 V5r3) to the sql server. The link uses a DSN connection that was created using the iseries driver v.10.00.06.00. The DSN works, I can create a sample app in visual basic that connects to the DB2 based on the dsn and does an update and all is good.
I created a strored procedure on the sql server that performs a select from a table on the linked DB2 and no problem, I changed it to an update statement and get the following error:
Provider returned message: SQL7008 - <table name> in <library> not valid for operation
I would really appreciate any advice on what this may be.
Thank you in advance,