question

MagdaMong avatar image
MagdaMong 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
sql-server-2005linked-serverodbc
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
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
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you for your reply. Allow inprocess is checked.
0 Likes 0 ·
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?
0 Likes 0 ·
MagdaMong avatar image
MagdaMong answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.