February 17, 2005 at 12:29 pm
Hi
I was able to run a SELECT statment on my linked server using four-part name. Now I am using the following statements:
INSERT INTO MYLINKEDSERVER.MYCATALOG.MYSCHEMA.MYTABLE (COL1)
VALUES ('VAL1')
But it says:-
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - MYTABLE in MYSCHEMA not valid for operation.]
Please note, it runs fine when executed on AS/400 directly. Also, in my DSN, I have set COMMIT = NONE.
Any ideas? Thanks
February 21, 2005 at 8:00 am
This was removed by the editor as SPAM
February 23, 2005 at 3:25 am
I think the user doesn't have write permission on that table.
March 29, 2005 at 2:35 pm
I found this quote at http://www.mcse.ms/archive85-2004-2-364893.html
Steve 2004-02-06, 11:33 am
Update on this. I have turned on journaling on the specific table I am trying to update, and updating/insert/delete works.
The problem is, that our 400 people do not want journaling turned on.
I have read that having the commit level set to *NONE the odbc
connection doesnt need journaling enabled. This however doesnt seem
to be the case.
Does anyone know a work around so that I can update the table without
having journaling turned on?
There was also other information on the thread that might be helpful.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply