Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cannot create an instance of OLE DB provider for linked server Expand / Collapse
Author
Message
Posted Thursday, September 4, 2008 12:24 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 2:55 PM
Points: 18, Visits: 102
Hi all,


When i log in to my SQL Server Management Studio with windows authentication

and

try to run a stored procedure (stored procedure pulls data from a linked server)

I get this error:

Cannot create an instance of OLE DB provider for linked server

provider name is: IBMDADB2

How can i fix this so that my query will run the Stored procedure and return data?

Thanks,

Sach
Post #564076
Posted Friday, December 12, 2008 1:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 21, 2009 8:51 AM
Points: 1, Visits: 6
Just thought I would post this much after the fact to get the info out in webspace for when I forget it next time...

Had the same problem setting up a Linked Server for Informix:
Cannot create an instance of OLE DB provider "Ifxoledbc" for linked server [...]

The solution was to follow the advice scattered about out there:

1. In SQL Server Manager, go to the Provider folder under the Server Objects folder and set the "Allow inprocess" box on the appropriate driver's properties
2. On the Server machine invoke the Component Services located at the Control Panel/Administrative:
• Expand Computer Services/Computers/My Computer/DCOM Config.
• Locate MSDAINITIALIZE and Right-Click on it.
• Click on the Security Tab.
• In the "Launch and Activation Permissions" click on "Customize", then click Edit.
• Add the users or appropriate group and check all permissions (Local Launch, Remote Launch, Local Activation, Remote Activation).

Good Luck!
Post #618915
Posted Monday, October 19, 2009 12:10 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 3:15 AM
Points: 157, Visits: 94
I experienced the same issue, and the setting above seemed to do the trick.

THe think I'm curious about is why was it that I would get error messages sporadically, and not consistently as permissions were involved. I was expecting consistent errors in initializing the component MSDAINITIALIZE. It seemed somewhat random however in that sometimes the data would retrieve and sometimes not.

Does anyone have a good explanation for the randomness?
Post #805221
Posted Tuesday, April 29, 2014 9:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 21, 2014 6:01 PM
Points: 1, Visits: 6
Good stuff. The Providers options did it for me.
Post #1566204
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse