November 17, 2015 at 4:39 am
Hi Folks,
So, I have a single Server with two instances on it; Prod and Test. The Windows Server is 2012 and the SQL Server 2014 (12.0.2000).
On this Server is the "IBM i Access for Windows" Driver so I can connect to the iSeries Server.
I use a SQL Server linked Server to connect to the IBM machine using the "IBM DB2 for i IBMDA400 OLE DB" Provider. Security is managed with configured remote user that all users will use.
On the Prod instance I run the following query....
select * from openquery([M3PRD],'select * from cbrfdbprd.artikel_dwh');
....and it returns the result set without any Problem.
In the test Environment, exactly the same query Returns 401 rows of a 1096 row result set and throws this error.....
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "IBMDA400" for linked server "M3PRD" reported an error. Provider caused a server fault in an external process.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "IBMDA400" for linked server "M3PRD".
SP_CONFIGURE Shows no significant differences between the instances and the "Test Connection" function works flawlessly.
Has anyone else encountered this Problem and if so, where did you find the solution? My wits have an end and it is in sight! 🙂
Thanks to all!
Regards,
Kev
November 17, 2015 at 2:01 pm
Did you enable the "Allow inprocess" option in the IBMDA400 Providers for Linked Services?
November 19, 2015 at 1:41 am
Many thanks for the reply and, yes, that was the Problem.
Thanks for a really quick Resolution!
Regards
Kev
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply