asked
ODBC Connection working, linked server fails
Hi, 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. Thanks SQL Server 2005 Windows Server 2003 IBMDADB2 driver
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. **[
http://www-01.ibm.com/support/docview.wss?uid=nas10366ef927408bcff862572bc00761f57][1]** [1]:
http://www-01.ibm.com/support/docview.wss?uid=nas10366ef927408bcff862572bc00761f57
How did you setup security for the Linked Server connection? Which login are you using to connect to SQL Server? Which service account is used for the SQL Server services? Did any of this information change recently?
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
