March 24, 2011 at 1:27 pm
I am trying to insert data and get the following error, but I can select with out any problems
OLE DB provider "MSDASQL" for linked server "Test_Export" returned message "[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - F0101Z2 in TESTDTA not valid for operation.".
Msg 7343, Level 16, State 2, Line 1
The OLE DB provider "MSDASQL" for linked server "Test_Export" could not INSERT INTO table "[MSDASQL]".
Can some one please help me
Thank you
May 19, 2011 at 10:47 am
Hi,
Did you figure this thing out yet? We are experiencing the same problem. Please do post, if you have the solution.
Regards,
Satish
May 20, 2011 at 6:53 am
I'm just curious why you would be getting a MSDASQL error on an IBM driver. In our linked servers we connect with either ODBC (where the provider is IBM) or OLE DB (where the provider is IBMDA400). In the provider properties (IBMDA400 for instance) we have Dynamic Parameter and Allow Inprocess checked. On occasion on 64-bit servers we need to use OPEN QUERY due to the version of the driver installed. I suggest you create another link and do some testing with various options. Good luck 🙂
May 20, 2011 at 6:55 am
Sorry, I forgot to mention to check the properties of the linked server and make sure that Rpc and Rpc Out are set to True.
May 20, 2011 at 9:28 am
From the file name, I'm assuming you are using JD Edwards, which we use.
In our setup we have to journal the file that we are uploading to in order to do inserts like this. We typically journal it to the OWJRNL/OW_JRNL which is part of the E1 setup, but you could use any journal.
Don Urquhart
May 20, 2011 at 10:17 am
None of the changes suggested for linked server and DSN worked for us. We will try journal the file and see what happens.
Satish
May 24, 2011 at 11:56 am
That's it. File Journal worked for us.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply