May 17, 2016 at 9:27 am
Greetings all!
I have a SQL 2000 server. There are many queries which goes to retrieve data from a DB2 server via linked server. These queries run fine when I do it with a sysadmin SQL user, but when I try to execute the queries with a sysadmin NT user, it returns the following error:
"
OLE DB error trace [Non-interface error: CoCreate of DSO for IBMDA400 returned 0x80040154].
Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB provider 'IBMDA400'.
"
I must add this case works perfectly in our production server, but fails in our development environment. I've been looking all over the web but haven't found an answer yet, so I'm taking this chance as my last resort.
Very grateful for your answers.
May 17, 2016 at 3:42 pm
No clue. If I had to guess it sounds like the linked server login settings are different on your dev and production boxes. I would start there. Take a look at the credentials for the linked servers in prod and dev to see if there are any glaring differences. Also it might be worth verifying on the DB2 side of the house if you can.
Joie Andrew
"Since 1982"
October 18, 2016 at 3:14 pm
After some months getting the problem for the first time, I stumbled upon it once again today, but got the solution now and I'll post here for future reference:
Simply check on "Allow Inprocess" in the provider used to handle the linked server (IBMDA400 in my case), this way the query now works with an NT user.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply