We have two linked servers set up to connect to two different DB2 servers, which have been working without problems for years.
Since last week both the linked servers fail with the following error:
Cannot create an instance of OLE DB provider for linked server (Microsof SQL Error 7302)
However, the ODBC connections still succeed when you test it from Data Sources (ODBC), in other words there are no problems with the network or permissions.
I've also tried to recreate the linked server but it still fails with the same error message.
Any suggestions will be appreciated.
SQL Server 2005 Windows Server 2003 IBMDADB2 driver
asked Mar 28 '11 at 01:54 AM in Default
This IBM Technote suggests setting the option Allow InProcess on the provider in SQL Server. I don't know if this is something that has changed with service packs and/or patches (you say it has been working before). But it might be worth testing. I'm using DB2Connect, so I'm not too familiar with this driver.
answered Mar 28 '11 at 02:21 AM
The problem seemed to be with SQL Server itself, we installed SQL Server 2005 SP4 and that seemed to resolve the problem.
Thank you for your assistance
answered Mar 28 '11 at 11:44 PM